Copying macros
 

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

Copying macros
 

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 Kahn" wrote in message
...
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

Copying macros
 

Michael,

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

--
sb
"Paul B" wrote in message
...
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 Kahn" wrote in message
...
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