Solved: Default file

[anthony20069]

Hi guys,

In MS Word, you are able to load the template.dot file as the default file - where you can edit certin settings etc. Is this possible to do within Excel?

I would like "Tools --> Options --> Secrurity --> "Remove personal information from file properties on save"" to be check everytime a users opens a Excel document.

Cheers

Anthony

[Bob Phillips]

Every time you do a New you get the template.

You can create your own version by saving a appropriately formatted workbook as Book.xlt, and save it in the XLStart directory.

[georgiboy]

Not sure on how to chek this option but you may be able to use something like this in a before save workbook event.

ActiveWorkbook.RemoveDocumentInformation (xlRDIPrinterPath)
ActiveWorkbook.RemoveDocumentInformation (xlRDIDocumentProperties)
ActiveWorkbook.RemoveDocumentInformation (xlRDIRemovePersonalInformation)

Hope this helps

[anthony20069]

Every time you do a New you get the template.

You can create your own version by saving a appropriately formatted workbook as Book.xlt, and save it in the XLStart directory.

Sorry for my stupidiness :), where and how do you change the XLStart directory?

cheers

[Bob Phillips]

You don't, but you can find out where it is by typing

?Application.StartupPath

in the immediate window.

[anthony20069]

which immediate window?

[Bob Phillips]

The VBIDE immediate window.

[anthony20069]

aagh ok, cool thanks. So i did that and the text changed to
Print Application.StartupPath
whats meant to happen?, when i save it and open again nothing is printed anywhere?

[Bob Phillips]

That means that you put it in a code module in a macro, not the immediate window. If you put it in the immediate window you it will return the directory path.