Moving a Macro (97)

[marcT]

Is there any way to move a macro that I saved in my personal macro list to be associated with the worksheet that I created it for? I am leaving the department that I currently work for and don't want to re-record the macro that I created (and saved in my personal list) so that someone else can administer/use it.

[HansV]

Open the target worksheet.
Activate the Visual Basic Editor (Tools/Macro/Visual Basic Editor or Alt+F11).
Make sure the Project Explorer is visible (View/Project Explorer or Ctrl+R).
Expand your Personal.xls. Expand Modules.
Now you can drag any module to the target worksheet. When you drop it, it will be copied to the target worksheet.

Another option is to export a module from Personal.xls and import it into the target worksheet. The export and import options are both in the File menu of the Visual Basic Editor.

[carbonnb]

Sure is a way to copy them.

1. <LI>Open The workbook you want to copy the macro to
   <LI>Press Alt-F11 to get to the VBE
   <LI>Add a new Module to your Workbook you are taking with you and open it
   <LI>Expand VBAProject (PERSONAL.XLS)
   <LI>Expand Modules
   <LI>Open the module that has the macro you want to copy
   <LI>Select the macro and Copy it
   <LI>Switch back to the module you created in step 3 and paste
   <LI>Repeat for all the macros you want to copy

If you want ALL the macros in a specific module, you can drag and drop the entire module from Personal.xls to the workbook you are taking.

One final option and I guess the easiest way overall is to just take the entire personal.xls file with you. That way you don't forget something.

[marcT]

Thanks to the both of you...worked great