Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming a standard module
Hey guys
how do I manually rename a standard module? I have allot of modules with the naming scheme of "Module1", "Module2", "Module3" and so on... Thanx Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming a standard module
Hi Todd
Do that in the Propeties window, (Name) field, down left in the VBE (or display it with the View menu if absent). And get yourself a stiff new years drink -bet you deserve a couple after this week's activity ;-) -- HTH. Best wishes Harald Followup to newsgroup only please "Todd Huttenstine" skrev i melding ... Hey guys how do I manually rename a standard module? I have allot of modules with the naming scheme of "Module1", "Module2", "Module3" and so on... Thanx Todd Huttenstine |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming a standard module
Todd,
Don't forget to rename the projects as well. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Harald Staff" wrote in message ... Hi Todd Do that in the Propeties window, (Name) field, down left in the VBE (or display it with the View menu if absent). And get yourself a stiff new years drink -bet you deserve a couple after this week's activity ;-) -- HTH. Best wishes Harald Followup to newsgroup only please "Todd Huttenstine" skrev i melding ... Hey guys how do I manually rename a standard module? I have allot of modules with the naming scheme of "Module1", "Module2", "Module3" and so on... Thanx Todd Huttenstine |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming a standard module
Thanks Harald. Your right, I'd much rather prefer
spending my time New Years with a few drinks than VBA. :-) thanks again Todd -----Original Message----- Hi Todd Do that in the Propeties window, (Name) field, down left in the VBE (or display it with the View menu if absent). And get yourself a stiff new years drink -bet you deserve a couple after this week's activity ;-) -- HTH. Best wishes Harald Followup to newsgroup only please "Todd Huttenstine" skrev i melding ... Hey guys how do I manually rename a standard module? I have allot of modules with the naming scheme of "Module1", "Module2", "Module3" and so on... Thanx Todd Huttenstine . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming a standard module
Todd,
To add to the excellent advice that you've already been given... It's not a good idea to name a module with the same name as a sub within that module. Can cause a lot of headaches. John "Todd Huttenstine" wrote in message ... Thanks Harald. Your right, I'd much rather prefer spending my time New Years with a few drinks than VBA. :-) thanks again Todd -----Original Message----- Hi Todd Do that in the Propeties window, (Name) field, down left in the VBE (or display it with the View menu if absent). And get yourself a stiff new years drink -bet you deserve a couple after this week's activity ;-) -- HTH. Best wishes Harald Followup to newsgroup only please "Todd Huttenstine" skrev i melding ... Hey guys how do I manually rename a standard module? I have allot of modules with the naming scheme of "Module1", "Module2", "Module3" and so on... Thanx Todd Huttenstine . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming a standard module
I've spent far too much time repairing my own lousy code written at times
where I was too exhausted to work properly. Nowadays I never ever work more than 12 hours on any day, no matter how long ago the deadline might have been. There's zero quality to my work after that so it just isn't worth it. But I'm old. My capacity was different in my twenties. Or perhaps I just like to think it was :-) Happy new year ! Best wishes Harald Followup to newsgroup only please "Todd Huttenstine" wrote in message ... Thanks Harald. Your right, I'd much rather prefer spending my time New Years with a few drinks than VBA. :-) thanks again Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to standard module | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
Variable from a sheet module in a class module in XL XP | Excel Programming | |||
Renaming VBA module | Excel Programming |