Unhide a sheet

[windsurfit]

I have a workbook with multiple sheets. Several are hidden but the names are available in the VB.

I am looking to permanently unhide my sheet with the name "Dist"

I have been over the forum but just looking for the basics here to unhide this one sheet and maybe the other sheets in my workbook.

Thx

 

[windsurfit]

Oye-

Ok, ran that and it came up as Workbook is Protected... surprising.. as there are no passwords etc to open and none of the sheet tabs (showing) have the "unprotect workbook" option.

Anyway to proceed?

 

[MARK858]

Under the Review tab is protect workbook highlighted? if yes what happens when you click it?

 

[windsurfit]

Yes, it defaults to that. That's what threw me. So when I click on it it says "Unprotect Workbook"

I was expecting "Unprotect Workbook" to be showing initially if it was protected. Confusing.

Anything possible?

 

[MARK858]

I was expecting "Unprotect Workbook" to be showing initially if it was protected. Confusing.

What you were expecting is correct but if it is saying protect Workbook then you should have had a dialog box appear when you clicked it that you haven't mentioned.

Anyway if it is protected then there isn't anything that I can do to help you as it is against the forum rules to help bypass or crack any protection.