Can't Unhide Worksheet

[RincewindWIZZ]

I wrote a spreadsheet for a chum some 3 years ago. Now it seems there is an anomaly (!) and I need to 'have a look'

The workbook has 3 sheets one of which is hidden. I need help to make this sheet visible
All sheets are unprotected
The workbook is unprotected

I have tried
Right Click on a sheet tab - 'unhide' is greyed out

VBA editor shows 3 sheets. The problem sheet has Name property "Sheet8" and is titled (referred to in the VBA code) as "ExpectedValue"
When I try to set the visible property (currently 0 - xlSheetHidden ) to visible (1) I get "UNable to set Visible property of the worksheet class"

When I try some VBA code

Sheets("ExpectedValue").Visible = True
I get error 1004 "UNable to set Visible property of the worksheet class"

In case I had named the sheet incorectly I tried
For Each WkSh In Worksheets: WkSh.Visible = True: Next
Same error 1004 "UNable to set Visible property of the worksheet class"

I actually cant change the Visible property for any of the sheets
I cant see anything sinister in workbook properties

So please how can I unhide this sheet?

 

[mikerickson]

It sounds like the workbook and/or the worksheets are protected. The protection has to be removed.
And this forum has a policy of not helping people crack passwords. I hope that both the sheet and the workbook are protected without a password.

 

[RincewindWIZZ]

The workbook has 3 sheets one of which is hidden. I need help to make this sheet visible
All sheets are unprotected
The workbook is unprotected

Any other ideas?

 

[Fluff]

Put this in a regular module of the workbook concerned

Sub chk()
MsgBox ThisWorkbook.ProtectStructure & vbLf & ThisWorkbook.ProtectWindows & vbLf & Sheet8.ProtectContents
End Sub

What does the message box say?

 

[RincewindWIZZ]

T
F
F

So it seems the structure is protected?
But view->protectsheet and View->Protect Workbook appear to offer to switch protection on!?

 

[RoryA]

In one of the great design blunders, the Protect Workbook button does not change caption, unlike the Protect worksheet button next to it. It does however get a slight shading to indicate that it is pressed.

 

[RincewindWIZZ]

Yes indeed - with the emphasis on slight!!
Very confusing for us mortals.

Anyway, I entered an appropriate password and the problem went away

Thanks Fluff

 

[Fluff]

Glad it's sorted & thanks for the feedback