where is the default excel templete stored?

[paul123456]

I would like to install a macro and have it be available on all excel document opened? do i do this by modifying the default template? were is this stored at..and is it possible?

Thanks, PAUL

 

[TonyJollans]

Hi Paul,

If this is just for your own use, you want to have the macro in your personal.xls workbook. It, along with anything else in the XLStart folder, will be automatically opened when you start Excel.

The easiest way to create one and have it put in the right place is to record a macro.
[ul]
[li]Select Tools > Macro > Record New Macro[/li]
[li]In the Record Macro Dialog, under Store Macro In, Select Personal Macro Workbook and Click OK[/li]
[li]Do anything at all (you are going to discard it later)[/li]
[li]Click the little square on the Stop Recording Toolbar (if you don't have it Select Tools > Macro > Stop Recording)[/li]
[li]Close Excel. You should be prompted to save the (new) personal macros.[/li]
[li]Re-Open Excel. Your Personal.xls Workbook will be opened as a hidden workbook, and you will be able to put your own macro in the personal.xls project in the VBA Editor, and it will always be available to you.[/li][/ul]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.