Macros editing and exporting

A

Anthony

Iwrite macros in a basic fashion, as in I select recording new macro and then
work thru the various steps on the worksheet.

I now wish to add another formula to an existing macro how do I do this.

When it is resaved I will then want to email it to anther computer user so
they can use it. How do you export and import macros

Thanks

anthony
 
P

Paul B

Anthony, F8, select your macro, edit, put in the code you want.

You can drag and drop the macros from one workbook to another in the VBA
editor, just open the workbooks and drag and drop. Or if it on another
computer you can export a macro and save it, to 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, in Project Explorer right
click on your workbook name, if you don't see it press CTRL + r to open the
Project Explorer 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 workbook.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top