xlSheetVeryHidden/xlSheetVisable

[Mr Wizard2]

I have a spreadsheet with significant VBA and five sheets. Only one sheet should be visible to the user. I currently have the main sheet and one other visible and three very hidden.

I tried to hide the one sheet and I get an error, "Unable to set the visible property of the worksheet class." I get the same error if I try to make the other sheets visible. Everything has been working fine until this cropped up. No problem with other workbooks.

Does anyone have any ideas regarding how to fix this? I could live with the extra sheet visible; however, I really need access to the currently hidden sheets.

 

[Mr Wizard2]

Thanks but I've got it. I apparently password protected the workbook and didn't realize it. Makes me feel like an idiot. Thank you for reading.