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/de...ificaddins.asp
Building Application Specific Add-Ins

http://msdn.microsoft.com/library/de...xceladdins.asp
Excel Add-Ins

http://msdn.microsoft.com/library/de...slibraries.asp
Add-ins, Templates, Wizards, and Libraries


--
HTH...

Jim Thomlinson


"Dave L" wrote:

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?