I'm sure this has a really simple solution, but I can't for the life of me find it:
How can make my macro available to all spreadsheets opened on a particular computer? - (i.e make it public/global)
Any help greatly appreciated!
Crane101
Printable View
I'm sure this has a really simple solution, but I can't for the life of me find it:
How can make my macro available to all spreadsheets opened on a particular computer? - (i.e make it public/global)
Any help greatly appreciated!
Crane101
Welcome to the Forums.
When you record the macro it prompts you for the location to store it in.
Select "Personal Macro Workbook" and it will be available to all of your workbooks.
It will only work on the app its opened in unless you do as RobDog posted.
If you look at your code, you add the word Public before the sub declarations.
If it is Private (just for that module) then its up to you whether you change it to Public.
Then to use in the same application you open the other workbook(s) and the code should be available.
Vince