MrExcel.com - Your One Stop for Excel Tips & Solutions

How do I rename a module?

Posted by Tim Grollman on January 10, 2002 5:06 AM

I have recorded a macro and saved it in my Personal file, but it just appears in there as Module 8. I can't see how to rename Module 8 so that it means something to me. Can anybody give me a clue please?

Posted by Bariloche on January 10, 2002 5:26 AM

Tim,

Open up the VB Editor (alt-F11) and make sure you have the Project Explorer and Properties windows open. Single left click on the offending "Module 8" in the Project Explorer. Then in the Properties window you should see the one and only property it has, which conveniently enough is "(Name)". Just edit that property to be whatever you want.


enjoy

Posted by Tim on January 11, 2002 6:05 AM


Many thanks - still learning.