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