Excel 2002 : How to rename a macro ?

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hello everybody,

It may be a silly question, but... Using Excel 2002, How can I rename the
different macros I created?

Thanks in adavance for your kind help.
Best regards,
Daniel
 
Daniel, press Alt+F11 to open the VBA editor, click on the module on the
left where your macros are stored and change the name there
--
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 2000 & 2003
 
Daniel

Excel store macros in the VBE. To open this enter Alt+F11. In the resultant
window, look for your workbook in the project explorer, below this you will
a module folder, double-click on one of the modules contained therein and at
the top of each procedure you will see 'Sub' followed by a name, change this
and save the project (Save in the VBE), now exit the vbe and save the
workbook. Remember code cannot have spaces in the name and certain
characters are not permissible either (*.\,/, etc)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Paul

That will only change the name of the module container, not the macros in
the macro list, which is what I felt Daniel was looking for?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top