Table of Contents | How i can create it without hidden Sheets?

[pacosalasv]

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.

[mehmetcik]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[pacosalasv]

It doesn't work, Debug error with

Please Login or Register  to view this content.

Any other suggestion / recommendation?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Andy Pope]

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.

[pacosalasv]

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

[Andy Pope]

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.

Please Login or Register  to view this content.

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.

[pacosalasv]

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.