Table of Contents | How i can create it without hidden Sheets?
Helo Experts, i need your support!
I modified a Macro Downloaded from Web, Its allocated in a Module for my Excel File in order to Create Table of Contents. The problem is that it includes HIDDEN sheets as well as part of the list. How i can create it without the hidden ones?
Here is the Full Module Code:
Please Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mehmetcik; 09-21-2020 at 04:37 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
It doesn't work, Debug error withAny other suggestion / recommendation?Please Login or Register to view this content.
Originally Posted by mehmetcik
It looks like the code already handles hidden sheets if you use the const in the code to ignore hidden sheets. Did you try that?
Please Login or Register to view this content.
I tried but not working, probably im using wrong code or logic.
could you help me with it, i mean, where and how i need to place it?
Thanks
I'm guessing that you modified the code such that you removed the code to deal with hidden sheets.
Modify the loop that builds the names of sheets to deal with.
The const still needs to be changed depending on whether hidden sheets are to be included or not.Please Login or Register to view this content.
Please Login or Register to view this content.
Works Flawless!!!
Thanks for support, if some one needs here is the code corrected with @Andy Pope support
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks