Copy a macro?

[Melissa]

Is there a way in Excel 2003 to copy or email a macro to another user? The
macro is saved in the Personal Workbook and created through the Excel macro
menu - NOT VBA, which I am not at all literate in. I'd like to put this
macro on another user's machine without having to re-record it on their pc.

Thanks,

Melissa

[DCSwearingen]

Most of the time a personal macro workbook is hidden.
Click Windows on the menu bar and then Unhide and select PERSONAL.XLS.

If a macro should be used by anyone using the workbook, it should probably be saved in the active workbook rather than in a personal macro workbook. Any macro saved in PERSONAL.XLS is available to any workbook opened on that computer, by the user who created it.

Press <ALT><F11> (press and hold the ALT key and then press the F11 key)

The Visual Basic Editor should be visible.

You may have to locate the macro you recorded - VIEW > PROJECT EXPLORER and scroll to VBAPROJECT (PERSONAL.XLS) and click the plus sign to the left.

Click the plus sign to the left of MODULES to see all of the modules in which you have recorded macros. You may have to look through several of these modules by double clicking on them. They are in chronological order if the one you are looking for was the most recent, it will probably be in the module with the highest module number.

Select the module by double clicking on it.

From the VBA Editor, click on FILE > EXPORT FILE

Give it a name if you want, but save it where you can find it from the next computer.

You should re-hide your personal macro workbook - See the very first step.

Go to the next computer and open Excel. Look to see if there is a hidden PERSONAL.XLS, if there is unhide it.

Open the VBA Editor <ALT><F11>.

From the VBA Editor File Menu, import the file you just saved.