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