What version of Excel are you using?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?
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.I am using 2010, I tried the other posters suggestion before I posted my question and it is not working.