Saving module as .xla

[Guest]

Hi,

I have created a couple of macros in VBA and want them to be available within Excel each time I open it, regardless of what file I open.

I believe saving the module as an .xla file will do the job, but I'm not sure.

Can anyone help?

Thanks in advance,
Stan

 

[Bob Flanagan]

Stan, Excel has a default workbook named Personal.xls that opens each time
Excel is open. It is created the first time you record a macro. It looks
like the best place to save your macros. The trick is to alwasy make it a
hidden workbook (Window, Hide)before saving ( if you unhide it and modify
it.).

If you made your workbook an xla add-in, then you would not see the macros
when you select Tools, Macros to run a macro. Instead, you would have to
either create buttons that run the macros, or create menu item additions to
run them.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

Hi,

I have created a couple of macros in VBA and want them to be available

within Excel each time I open it, regardless of what file I open.