Copy a macro?
 

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

Copy a macro?
 

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.

"Melissa" wrote:

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

Copy a macro?
 

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.


--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=565297