Error message when selecting hidden files

[alexshaw76]

Very new to excel VBA
I have a sheet labeled TOC with buttons on it linking to other sheets in the workbook. I have hidden certain sheets until they are needed but just realized that when clicking on a button on the TOC it brings up a error. I would like to have to separate options
1. when selected it brings up a msgbox asking if i would like to unhide the hidden cells one at a time.
2. when selected it brings up a msgbox just saying this sheet is hidden.

My code to select the sheets with the button is:

Please Login or Register  to view this content.

My code to select the sheets to be unhidden one at a time is:

Please Login or Register  to view this content.

I don't have a code to simply say the sheet is hidden yet.

Any help would be much appreciated.

[stnkynts]

You can incorporate the first code you have, if you would like:

Please Login or Register  to view this content.

You can then unhide it if you wanted to. You didn't mention that in your post so I didn't include code (you did say something about hidden cells but worksheets and cells are different things).

[alexshaw76]

thanks STNKYNTS works great!