Display Worksheet Properties (visible/Hidden) on UserForm via Label Caption Dynamically

Hello Everyone,

Reaching out for a little help. I’m trying to create a worksheet manager, and in my userform I’m trying to capture the number of sheet as well as the number visible and hidden sheets via Label.Caption and failing miserably. Below is the code I’m using. I can get the number of sheets, but can’t figure out how to count the number of visible and hidden sheets. I’ve included the workbook. Any help is appreciated.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

https://www.mrexcel.com/board/thread...sheets.550270/

Logit,

Thank you for the speedy reply. This code is ideal. However, I'm not looking for a msgbox per se. I'd like to reflect the data via label captions on my UserForm. How can manipulate the code to do that.

rb

Paste in the UserForm :

Please Login or Register  to view this content.

Logit,

I've added it to the UserForm_Initialize() and it works just how i envisioned. thank you sooo much!!! now, i just have to figure out how to include protected and unprotected sheets, but i suppose i'll have save that for another post.

rb

Glad to help.