Hide Sheet Is not Available

[DougStroud]

Why and how to resolve. A spreadsheet sent to us by a colleague will not allow a tab/sheet to be hidden. Remedies and reason(s)? Could it have to do with it being a macro enabled sheet?

 

[Fluff]

Check to see if the workbook (rather than the sheet) is protected.
On the Review tab if "Protect workbook" is highlighted, then its protected.

 

[DougStroud]

Check to see if the workbook (rather than the sheet) is protected.
On the Review tab if "Protect workbook" is highlighted, then its protected.

Thank you! That was it.

 

[Fluff]

You're welcome & thanks for the feedback