Chuck

I prefer to leave the other Personal.xls alone.

Copy the macro from your Personal.xls to a new workbook.

To copy a macro from Personal.xls first have your new workbook open.

Hit ALT + F11 to open the VB Editor.

CTRL + r to open the Project Explorer window.

You will see your new workbook and personal.xls

Right-click on your new workbook and InsertModule

Close that and double-click on the Module1 on Personal.xls

Copy the macro text and close the window.

Double-click on the new workbook Module1 and paste the macro in.

Save that new workbook as an Add-in under FileSave AsFile typeAdd-in(*.xla)

Copy that to a folder on the netword and the other users can point to that
add-in under ToolsAdd-insBrowse.

You can add more macros to the add-in as you create them.


Gord Dibben MS Excel MVP

On Tue, 13 Feb 2007 11:07:01 -0800, ChuckW wrote:

Dave,

I checked the macro on the PC at it is called Personal.xls!Macro1. I think
it is stored in the Personal Macro Workbook. There are three other PCs on
the same domain that I want to have this run on. It would be possible to
move this to a common folder on the network if this is possble. Otherwise it
would be great if I could just copy this macro and move it to the local
drives of the other PCs.

Thanks,