| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any way to change the name of a Module?
You could change the name of a VBA module in prior versions of Excel. I
can't seem to be able to do this in Excel 2003. I don't like having names like Module1, Module2... Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there any way to change the name of a Module?
Same way, in the VBIDE, select the module, open the Properties window (F4)
and change it there. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Keith Rebello" wrote in message news:pWLMf.188871$oG.53304@dukeread02... You could change the name of a VBA module in prior versions of Excel. I can't seem to be able to do this in Excel 2003. I don't like having names like Module1, Module2... Any help would be appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there any way to change the name of a Module?
Just click on the module in the VBE and then down below in the properties
pane against the field (Name) change it to whatever you want. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Keith Rebello" wrote in message news:pWLMf.188871$oG.53304@dukeread02... You could change the name of a VBA module in prior versions of Excel. I can't seem to be able to do this in Excel 2003. I don't like having names like Module1, Module2... Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to change the name of a module in VBA? | Excel Discussion (Misc queries) | |||
| Is it possible to change the name of a module in VBA? | Excel Discussion (Misc queries) | |||
| Module name change | Excel Programming | |||
| Can't edit module? How do i change this? | Excel Programming | |||
| Default in a textbox and change a module name | Excel Programming | |||
Linear Mode
