Unable to set a worksheet to Visible

[jhol4]

I have an auto open macro that automatically take you to a sheet, then when you click on continue it will hide the sheet and take you to an index page.

My problem is that all of a sudden, this just stopped working. It started debugging at the 'Sheets("Disclaimer").Visible = True' command. Even when I try to manually set the sheet to visible, I get an error message saying "Unable to set the visible property of the worksheet class"

As I said, I have never had problems with this before, and the model just started doing this for no apparant reason.

Any suggestions would be greatly appreciated.

Thanks

 

[Tom Urtis]

Try this line just for the heck of it and see if it solves anything:

Sheets("Disclaimer").Visible = xlSheetVisible

 

[jhol4]

Thanks Tom, but that just gives me the same error.

Maybe it has corrupted?

 

[jhol4]

Just in addition to this, I seem to have lost the ability to do a lot of editing type stuff. When I click on the Format->Sheet menu, the only available option is 'Background'. Or when I right click on the sheet tab, the only options are view code or select all sheets.

Something has gone horribly wrong here!

 

[Tom Urtis]

Post all your code, and make *sure* you have the sheet tab name spelled exactly the same way as how it is spelled in the code (though you'd get a 9 error, just thinking out loud). Maybe someone can spot something in the code. Also, tell us what version(s) of Excel are being used.

 

[Tom Urtis]

Maybe the macros are being disabled, or not enabled, by system or network settings? Maybe events are disabled?

 

[jhol4]

Problem Solved! A collegue had protected the workbook without me knowing!

Thanks