T
Tenaj
Is there a way to create one marco in a way that I can use it in multiple
workbooks?
workbooks?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
akphidelt
When you go to record a new macro... it will give you an option that says
"store macro in"
Select "Personal Macro Workbook"
That should save it and allow it to be used by all workbooks.
"store macro in"
Select "Personal Macro Workbook"
That should save it and allow it to be used by all workbooks.
T
Tenaj
I did that but couldnt figure out how to get it to work in other workbooks.
A
akphidelt
After you save it in your personal macro book you should be able to open up
another excel workbook... go to
Tools--> Macro --> Macros
And you will see it listed in the Macro box.
another excel workbook... go to
Tools--> Macro --> Macros
And you will see it listed in the Macro box.
T
Tenaj
After I closed my personal macro book and reopened it now it does show up in
the other work books. Thank you so much
the other work books. Thank you so much
A
akphidelt
No problem, thanks for the feedback!
Tenaj said:After I closed my personal macro book and reopened it now it does show up in
the other work books. Thank you so much