• 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.

VBA Editor has too many sheets counting till almost 100

Puneetk

New Member
Hi guys,

The VBA editor of one of my workbooks containing 2-3 macros shows too many sheets almost 100 of them and so many "this workbook" items under Microsoft excel objects. Can help me understand what are these and does it impact the performance of my macros. Also, can I delete them and If yes how can I delete them. Attaching a screenshot for your reference, please.

Will really appreciate your help. thanks in advance.
 

Attachments

  • Screenshot 2021-04-19 at 8.26.16 AM.png
    Screenshot 2021-04-19 at 8.26.16 AM.png
    99.3 KB · Views: 8
  • Screenshot 2021-04-19 at 8.29.16 AM.png
    Screenshot 2021-04-19 at 8.29.16 AM.png
    150 KB · Views: 8
Hi, as it seems broken, damaged so restart from a backup or create a new workbook …​
 
Back
Top