Sweedler
Board Regular
- Joined
- Nov 13, 2020
- Messages
- 124
- Office Version
- 2016
- Platform
- Windows
- MacOS
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.