Have created a few macros, which are currently store in my personal macro workbook.
I want to make the macros available for many users in my company, but I keep updating the macros.
Can I export the module from my personal macro workbook and store them on our shared drive.
What is the best format to keep macros in. To be able to run them quickly.
If they are stored in excel workbooks, they can take long time to open and run.
How do I reference a macro stored in a module (BAS file) stored on the shared drive?
I want to make the macros available for many users in my company, but I keep updating the macros.
Can I export the module from my personal macro workbook and store them on our shared drive.
What is the best format to keep macros in. To be able to run them quickly.
If they are stored in excel workbooks, they can take long time to open and run.
How do I reference a macro stored in a module (BAS file) stored on the shared drive?
