Renaming module (Excel 97/SR2/VBA)

Topic

New Reply

Is there a way to rename a module for an excel project?

Reply | Quote

Replies

In the VBE, if they aren’t already visible, display the properties window and project explorer. Click on the module you want to rename in the project explorer and in the properties window you should see the name of your module repeated twice – once with “module” after it and once with (Name) before it. Click on the one with (Name) before it and you can rename your module.

Brooke

Reply | Quote

Thanks for the response Brooke. After sleeping on this, I woke up and remembered the exact thing that you posted. Probably should be careful when it is past my bedtime.

Reply | Quote