Exporting/copying Excel Macros

mqarep · Mar 13th, 2002, 12:46 PM

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 · Mar 13th, 2002, 12:49 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 12:46 PM	#1
mqarep Board Regular Join Date: Mar 2002 Posts: 91	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.

Mar 13th, 2002, 12:49 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	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 ]