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.

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.

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.