Copying macros

  • Thread starter Thread starter Michael Kahn
  • Start date Start date
M

Michael Kahn

I placed a number of macros in personal.xls on one
machine. I'm trying to move those macros to another
machine. How can I copy those macros from personal.xls to
another spreadsheet? Also does anyone know why I have so
much trouble copying personal.xls. Thanks. Michael
 
Michael, I would export the macro, to export a macro and save it, do this
from your workbook, right-click the workbook's icon and pick View Code. This
icon is to the left of the "File" menu this will open the VBA editor, click
on the module you want to save and go to file and export file, then save it
to a floppy or what ever you backup to, then import it to the new workbooks

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Michael,

You can just drag the macros from one workbook to another in the VBE.
Just open the workbook and start dragging and dropping...
 
Back
Top