Easy Import for Excel Macros?

[nkrst1]

Is there an easy way to import a macro in Excel like there is in Access? I know you can copy and paste, click drag, etc. in the VB editor. I also know you can select different macros from other open workbooks through the Alt+F8 menu, but Is there an easier way? I would like to send this out to more "non-technical" users, and I don't want them diving into VB.

Thanks in advance.

-n-

 

[dsi]

You could export the module (right-click, export file) and share it. Then, the other users would just have to go to the VB editor and select Insert > File and select the .bas file. In this case, the macro should be written in a separate module, not in the sheet object.