Forum Discussion
Patty1228
Jan 20, 2022Copper Contributor
Where do I save my Macro?
I need to create a Macro in Excel (version 2111) (Dell Computer) and I never can get mine to work/be available when I open "other" excel files. I guess I need to know "where do I save my macro" so t...
HansVogelaar
Jan 20, 2022MVP
If you want your macro to be available in ALL workbooks, choose Personal Macro Workbook.
When you quit Excel, it will ask you whether you want to save changes to your Personal Macro Workbook. Answer Yes, otherwise your macro will be lost!
- Patty1228Jan 20, 2022Copper Contributor
HansVogelaar Thank you! I will give that a try!