I cannot hide a sheet in a workbook. Why?

O

Otto Moehrbach

Is it the only visible sheet in the file? Exactly what are you doing to
hide the sheet? HTH Otto
 
J

JRC

Otto Moehrbach said:
Is it the only visible sheet in the file? Exactly what are you doing to
hide the sheet? HTH Otto



Thanks for the reply. I am going to the "format" drop down menu but the "Hide Option does not appear. I was able to hide a sheet before so I think I may have altered one of the settings by mistake. Any idea what I may have done wrong?
Click to expand...

Thanks!
 
G

Gord Dibben

It is quite possible that the workbook is protected, thus not allowing you to
hide sheets.

Tools>Protection>UnProtect Workbook.

You may need to supply a passwrd.


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Not so strange.

You can hide protected sheets.

I did not say the worksheet was protected, I said the WORKBOOK was protected.


Gord
 
M

Mark Lincoln

You certainly did, and I somehow managed to absolutely misread it. My
apologies.
 
G

Gord Dibben

Mark

Thanks for that.

You are talking to the King of mis-reads so I have great empathy.


Gord

You certainly did, and I somehow managed to absolutely misread it. My
apologies.
Click to expand...

Gord Dibben MS Excel MVP
 
Top