Renaming a macro

todds123 · Mar 26th, 2002, 02:52 PM

Once I have named a macro, how can I change the name that appears when I select MACRO and it gives me the list of macros in that workbook. When I click edit and try to do it where I thought I could, no dice. I am a new macro user.

[ This Message was edited by: todds123 on 2002-03-27 10:03 ]

[ This Message was edited by: todds123 on 2002-03-27 10:04 ]

Jack in the UK · Mar 26th, 2002, 02:56 PM

hi

the name you refer to is the sub name not module name...

Jack in the UK · Mar 26th, 2002, 02:58 PM

BTW these names must be one word and not the same

JackintheUK
Jack_in_the_UK

Mar 26th, 2002, 02:56 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	hi the name you refer to is the sub name not module name... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Mar 26th, 2002, 02:58 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	BTW these names must be one word and not the same JackintheUK Jack_in_the_UK __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 02:52 PM	#1
todds123 New Member Join Date: Mar 2002 Posts: 1	Once I have named a macro, how can I change the name that appears when I select MACRO and it gives me the list of macros in that workbook. When I click edit and try to do it where I thought I could, no dice. I am a new macro user. [ This Message was edited by: todds123 on 2002-03-27 10:03 ] [ This Message was edited by: todds123 on 2002-03-27 10:04 ]