The easiest way is to copy your personal.xls to her pc. It resides at:
C:\Documents and Settings\UserName\Application
Data\Microsoft\Excel\XLSTART

Otherwise press Alt+F11 to open the VBE editor, then find your macro
and copy everything from "Sub YourMacro" to "End Sub" into an email and
send that to your coworker. Have her open the editor and paste that
code into her personal.xls.

Charles

RUSH2CROCHET wrote:
Hello:

Running Excel 2003. Am very new to Visual Basic, but have recorded a simple
page formatting macro to include margins, header, footer, font size, style,
etc. This was saved to Personal Macro Workbook, and used twice weekly to
format (4) downloads into one file for distribution to sales team.

Responsibility for report transferred to fellow team member, (who is
unfamiliar with macros & their recording.) Without re-recording, would like
to send macro from my Personal Macro Workbook, to hers, and unsure how to
accomplish this. Any and all suggestions welcome!

TIA,
Sandi