Macro for all Workbooks

[beirrac]

I am trying to write a macro that I can use in all workbooks and I can't figure out where/how to save the macro so whenever I open excel it is available. I tried saving a personal.xls in the xlstart folder, but it didn't work. Any suggestions?

 

[sweeneytime]

I had issues with that too, the work around I use is: save the workbook in the windows startup folder, then the excel sheet will always be open when you start the computer.

StartMenu -> Programs -> Startupfolder.

 

[JoeMo]

I am trying to write a macro that I can use in all workbooks and I can't figure out where/how to save the macro so whenever I open excel it is available. I tried saving a personal.xls in the xlstart folder, but it didn't work. Any suggestions?

What version of Excel are you using?

 

[beirrac]

I am using 2010, I tried the other posters suggestion before I posted my question and it is not working.

 

[JoeMo]

I am using 2010, I tried the other posters suggestion before I posted my question and it is not working.

Easiest way to create a PERSONAL.XLSB workbook is to record a simple macro. When the record macro dialog box opens set the store in dropdown to personal. This will create the PERSONAL.XLSB file (note not .xls) and save it to the XLSTART folder on your main drive.