Tue 18 Nov 2008, 16:31Delegate Marta said...
Marta has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA
How do you change the name of an existing macro?
Mon 2 Feb 2009, 15:43Trainer Carlos said...
RE: Excel VBA
Hi Marta
When a macro is created the code appears in a Module in the VB Editor. To change the name:
1. Open the VBE and double click the relevant Module
2. Highlight the macro's name in the Sun line eg:
Sub MacroName()
3. Write the new name as
Sub MyNewName()
The macro will now only run if the new name is called
Hope this helps
Carlos
