Exporting/copying Excel Macros

[mqarep]

How do I export/copy macros from one computer to another? When I send my spreadsheet to another user, the custom macro buttons on the toolbar do not transfer with the file. Therefore the user cannot run the macros.

 

[NateO]

They can still run them, they just need to have access to the vbe or know the procedure's name.

Either make an Add-in, or more simply, make the buttons in the worksheet itself instead of the toolbar.

Hope this helps. Cheers,

Nate
This message was edited by NateO on 2002-03-13 11:49