SQLSearcher
asked on
Excel Marco to load in every spreadsheet
Hello Experts Exchange
Is it possible to save a Excel Marco once and have it available for every spreadsheet I open on my machine?
Regards
SQLSearcher
Is it possible to save a Excel Marco once and have it available for every spreadsheet I open on my machine?
Regards
SQLSearcher
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much for your help.
On the Developer tab, in the Code group, click Record Macro.
Record Macro
In the Record Macro dialog box, type a name for the macro in the Macro name box, such as BoldMe. Make sure you don’t use any spaces in the name.
In the Store macro in box, select Personal Macro Workbook.
Record Macro dialog box
Click OK.
On the Developer tab, in the Code group, click Stop Recording.
Stop Recording
Close any open workbooks and then exit Excel.
A message appears that prompts you to save the changes that you made to the Personal Macro Workbook.
Click Yes to save the personal workbook.
Now next time when you open excel, press Alt+F11 and then personal.xlsb will always be available. Add your code to any of the modules in personal.xlsb