Sweedler
Board Regular
- Joined
- Nov 13, 2020
- Messages
- 132
- Office Version
- 365
- Platform
- Windows
Hello
I have a tab the lists all the tabs in a workbook. Several of the tabs that I have do not have any information and are "HIDDEN". But I need to have an overview of this on the index tab (that is the one that lists all the tab names. Does anyone know a formula that I can use to list a "HIDDEN" / "SHOWING" value in the column next to the filename. It would make my life a whole lot easier.
I have a tab the lists all the tabs in a workbook. Several of the tabs that I have do not have any information and are "HIDDEN". But I need to have an overview of this on the index tab (that is the one that lists all the tab names. Does anyone know a formula that I can use to list a "HIDDEN" / "SHOWING" value in the column next to the filename. It would make my life a whole lot easier.