Archive of Mr Excel Message Board


Back to Excel VBA archive index
Back to archive home





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?

Check out our Excel VBA Resources

Re: How do I rename a module?

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


Re: How do I rename a module?

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

Many thanks - still learning.



This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.