Excel Macro save and re-use for multiple projects

[PleaseGiveHelp]

I've read that a macro is only good for the current project. Thus if I wanted to use a macro for another project/worksheet I'd need to re-create the macro. Is there ANY way to go around this? I have a macro that I'd like to use for MANY worksheets. Many worksheets have yet to be created. But instead of copying and pasting EVERY time I create a new worksheet, is there any other way to call a macro? Or even if I have to create a program that has the macro code in it...any ideas on how this could work/be created?

 

[SkipVought]

Hi,

If you have a Personal.xls set up that opens each time you start Excel, this is the place to save your common macros.

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[PleaseGiveHelp]

I think I spoke too soon. I simply put my macro in as a function in my VB application and call the macro from the load form function. It seems to work except it doesn't seem to recognize my save commands...I have an unload so that after the form is selected, the file opened, the macro run, I save the spreadsheet and unload the form...however I am still prompted to save the spreadsheet when it should recognize my save command...it doesn't.