renaming VBA "modules"

[windsurferLA]

I’m running XL97 under WinXP-pro. Associated with an XL97 workbook are
numerous macros in various “modules” in a VBA Project. Some of these
“modules” have informative names while others are merely named Module1,
or Module2. I’m not sure how some ended up with appropriate names
while the others simply have a generic title.

Is there a way to change these module names?

 

[Norman Jones]

Hi Windsurfer,

Select the module in the explorer window (Ctrl-R), open the properties
window (F4) and change the module's name property.

 

[Guest]

Or you can select a module (in the Project Explorer), press F4 on your
keyboard twice. Then type a new name.

It's always a good idea to give the modules consistent descriptive names.

Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com

 

[windsurferLA]

Thanks.... works

Hi Windsurfer,

Select the module in the explorer window (Ctrl-R), open the properties
window (F4) and change the module's name property.

 

[windsurferLA]

Thanks ... works... it is obvious now that I see what to do.