• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Removing Modules from Visual Basic Editor

fred

Member
Hi,


I have created a file with 6 macros. Over time, I had to delete some of them and create new ones. So when I am in VBE I see there are over 40 modules.


Questions:

1. Is it save to remove those that are blank?

2. Will removing the blank modules hurt the one I'm still using?

3. Why are the blank modules still showing up, after I have them deleted?


Fred
 
1. Yes, if they're completely blank, go ahead

2. No. Again, if it's blank, there should be nothing in the module that is being referred to in other module.

3. Sounds like you deleted the "macro", not the module. You need to right click on the module, click "remove", and then click "no" (do not export).
 
Back
Top