Is there any way to change the name of a Module?

[Keith Rebello]

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.

 

[Bob Phillips]

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)

 

[Ken Wright]

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
------------------------------­------------------------------­----------------