How to easily (!) load Macros from external files on demand?

  • Thread starter Thread starter Artur McCennon
  • Start date Start date
A

Artur McCennon

Assume I have a VB macro for Excel in an external text file mymacro.vb

Now I open a worksheet in Excel and want to have this macro available.

Ok, I could load it with ALT+F11 into Macro Editor and the launch it with lots of menu clicks
but this is somehow cumbersome and unconvenient.

I am searching for a way to (double)click on this macro file or drag it onto Excel and have it
immediately available.

Is something like this possible?

Arthur
 
You may want to take an alternative approach.

Create a workbook with the macro already in it and save it as a Template (*.xlt
or *.xltm). Then instead of starting a empty workbook, use that template file.

One thing nice about this is that you don't have to worry about the user's
security settings (if you share it other users) and you can protect the project
in the template.
 
Back
Top