Force Excel Template

[Boyce]

I am aware that by placing a workbook in the;

C:\Program Files\Microsoft Office\OFFICE11\XLSTART directory will make excel use the template on opening, but does anyone know of a way to avoid the File > New > Templates on My Computer (screenshot attached)? The idea being, users have no intervention and a company template is enforced.

Office 2003, Active Directory Network

I have looked through the Office and adm templates (links below), but cannot see a way to do this.

Any suggestions greatly received!

http://office.microsoft.com/en-gb/he...513711033.aspx

http://www.microsoft.com/office/orkarchive/2003ddl.htm

http://support.microsoft.com/kb/816662

Thanks

[Stoney]

Do you want them to not be able to create or use a new template, or just from being able to use another template?

[Boyce]

Stoney,

Thanks for your reply.

The idea being, one template is used across the company (so, i suppose if it would work by preventing them being created - great!) and there is no user intervention when selecting File > New - a new workbook appears with the company template and not asked where to look.

Simon

[Stoney]

You may be able to do it using a macro;

Workbook.Add(Template=:".")

Not sure how you'd get the Macro to run in every instance of excel??

Actually I think that may save the workbook as a template rather than opening a specific template!

[Boyce]

Thanks for your help Stoney.

I will let you know what happens.