Copy a macro?

[Guest]

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

 

[Guest]

In the first place, a macro is and will always be VBA!

To mail the macro to someone, press<Alt><F11>, double click on the
Personal.xls in the left hand window, double click on Module 1, or any other
module it may be recorded in. Select the script, click <Ctrl><C>, open a new
email, click in the body, and press <Ctrl><V>, and send it. The recipient
can select the script in the mail received, copy it and paste it into their
own Personal.xls Module 1 or whatever.

 

[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 shoul
probably be saved in the active workbook rather than in a persona
macro workbook. Any macro saved in PERSONAL.XLS is available to an
workbook opened on that computer, by the user who created it*.-

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

The Visual Basic Editor should be visible.

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

Click the plus sign to the left of MODULES to see all of the modules i
which you have recorded macros. You may have to look through several o
these modules by double clicking on them. They are in chronologica
order if the one you are looking for was the most recent, it wil
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 th
next computer.

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

Go to the next computer and open Excel. Look to see if there is
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