Macro Help

D

Dave L

Is there any way to copy a macro that is stored in your Personal Macro
Workbook and transfer it to a different user at a different computer? Can I
e-mail it to another user?
 
J

Jim Thomlinson

You really want an Addin for doing that... Check out these links

http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000

http://msdn.microsoft.com/library/d...ml/deovrbuildingapplicationspecificaddins.asp
Building Application Specific Add-Ins

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deovrexceladdins.asp
Excel Add-Ins

http://msdn.microsoft.com/library/d...html/deovraddinstemplateswizardslibraries.asp
Add-ins, Templates, Wizards, and Libraries
 
G

Gord Dibben

ALT + F11 to get to the VBE.

Double-click on your module to open it.

Copy the macro text and paste into the body of your email to other user.

OU can then copy and paste to a module in his Personal.xls.


Gord Dibben MS Excel MVP
 
Top