scotthannaford1973
Board Regular
- Joined
- Sep 27, 2017
- Messages
- 110
- Office Version
- 2010
- Platform
- Windows
Hi all
I have a workbook with a lot of worksheets that get hidden and unhidden a lot and I'd like to add a table that, for each worksheet listed, there is a cell that shows that worksheet's visibility table.
Is there any code I can use that just shows that status and adds it into a cell? I don't want to list the status for every worksheet in the workbook, but just for those I list in the table. It could be one piece of code listing them all, or one piece of code per worksheet.
thanks!
I have a workbook with a lot of worksheets that get hidden and unhidden a lot and I'd like to add a table that, for each worksheet listed, there is a cell that shows that worksheet's visibility table.
Is there any code I can use that just shows that status and adds it into a cell? I don't want to list the status for every worksheet in the workbook, but just for those I list in the table. It could be one piece of code listing them all, or one piece of code per worksheet.
thanks!
WORKSHEET NAME | VISIBILITY STATUS |
Worksheet2 | Visible |
Worksheet3 | Hidden |
Worksheet4 | Hidden |
Worksheet5 | Visible |