Dear Friends,
I have several modules in a workbook. They are named by default as module 1, module 2, module 3, ... which confuse me which module i want to edit. I have to open each module and see the code which I don't want. To avoide this I want to rename the module as per its function or as per my requirement.
Please suggest me the method to rename a module easily for easy finding.
Thank you.
Mukesh
- Open the Properties window (F4)
- Click on the module you want to rename
- You can change its name in the Properties window.
Hi Mukesh,
From within the Visual Basic Editor, simply click on the existing module (from the left-hand Project - VBAProject panel) you wish to change and enter the desired name in the Name field of the Properties pane. Just make sure the module name is different from any macro name within the module to avoid any conflict.
HTH
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Hello AlphaFrog,
Thank you it's working fine.
Mukesh
Hello Trebor76,
Thank you.
Mukesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks