How do I make a macro available for all workbooks to use?
I have the code that I paste in to an individual spreadsheet using the Alt F11 ---> Insert Module (paste in code).
But the macro is only available for that workbook. How do I make this macro available for any workbook that I open up in the future?
This is what you are looking for: https://trumpexcel.com/personal-macro-workbook/
Click the * to say thanks.
Thanks for your response but I wasn't able to get these to work. These steps have me recording the macro. I don't know exactly what the macro is doing in order to record it. All that I have is a word document with the macro code. I just want to be able to drop that code in somewhere and have it available for all workbooks. Thanks.
Follow the exact steps in there to create a personal.xlsb workbook. Just record something, no need to be important. Then replace that macro with yours and voila, you can use it in all workbooks
Thank you. That worked! Now I understand!!
Glad I could help. If it took care of your problem, please mark the thread as Solved from Thread Tools.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks