Does excel have a global template i could add a vb macro to?

[Deb]

I want the macro to be available everytime I open a new
workbook... does excel have a global template i can
modify? if so what is the name? where do i find it? and is
it modifiable?

Thanks!

Deb

 

[J.E. McGimpsey]

Create a new workbook. Format it the way you want new workbooks to
be formatted, add macros, etc.

Save it in the XLStart directory as a template with the name
"Book.xlt". That workbook will be used from then on to create your
new workbooks. You can also create a Sheet.xlt template that you put
in the same directory that will be used as a template when you
choose Insert/Worksheet.

 

[steve]

Deb,

Excel has what is called a Personal.xls. It is stored in the XLStart folder
in the Office folder. But you have to first create it.

The easiest way is to record a macro (anything) and in the Record Macro
dialog box select Personal Macro Workbook in the Store macro in: box.

Than go to the VBE and start editing and writing...

Your Personal.xls will open everytime you open Excel and it will be hidden.
Keep in mind that it is only on your computer.

But - any workbook that you put in the XLStart folder will do the same
thing.

And then there are things called Add-Ins. Check the help on those. They
are similar. But you can send them to other people and have them load them
in Excel. You load them by going to the Tools menu and select Add-Ins.