I cannot hide a sheet in a workbook. Why?
 

I cannot hide a sheet in a workbook. Why?
 

Is it the only visible sheet in the file? Exactly what are you doing to
hide the sheet? HTH Otto
"JRC" wrote in message
...

I cannot hide a sheet in a workbook. Why?
 

"Otto Moehrbach" wrote:

Is it the only visible sheet in the file? Exactly what are you doing to
hide the sheet? HTH Otto
"JRC" wrote in message
...



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?

Thanks!

I cannot hide a sheet in a workbook. Why?
 

Try Format|Sheet|Hide

JRC wrote:

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?

Thanks!

I cannot hide a sheet in a workbook. Why?
 

Are you doing Format - Sheet - Hide as Mark suggests? HTH Otto
"JRC" wrote in message
...


"Otto Moehrbach" wrote:

Is it the only visible sheet in the file? Exactly what are you doing to
hide the sheet? HTH Otto
"JRC" wrote in message
...



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?

Thanks!

I cannot hide a sheet in a workbook. Why?
 

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

ToolsProtectionUnProtect Workbook.

You may need to supply a passwrd.


Gord Dibben MS Excel MVP

On Tue, 3 Oct 2006 09:52:02 -0700, JRC wrote:



"Otto Moehrbach" wrote:

Is it the only visible sheet in the file? Exactly what are you doing to
hide the sheet? HTH Otto
"JRC" wrote in message
...



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?

Thanks!

I cannot hide a sheet in a workbook. Why?
 

I am able to hide a protected worksheet in Excel 2003. Strange, but
true. :)

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

ToolsProtectionUnProtect Workbook.

You may need to supply a passwrd.

I cannot hide a sheet in a workbook. Why?
 

Not so strange.

You can hide protected sheets.

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


Gord


On 9 Oct 2006 13:05:24 -0700, "Mark Lincoln" wrote:

I am able to hide a protected worksheet in Excel 2003. Strange, but
true. :)

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

ToolsProtectionUnProtect Workbook.

You may need to supply a passwrd.

I cannot hide a sheet in a workbook. Why?
 

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

Gord Dibben wrote:
Not so strange.

You can hide protected sheets.

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


Gord


On 9 Oct 2006 13:05:24 -0700, "Mark Lincoln" wrote:

I am able to hide a protected worksheet in Excel 2003. Strange, but
true. :)

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

ToolsProtectionUnProtect Workbook.

You may need to supply a passwrd.

I cannot hide a sheet in a workbook. Why?
 

Mark

Thanks for that.

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


Gord

On 10 Oct 2006 08:00:03 -0700, "Mark Lincoln" wrote:

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

Gord Dibben wrote:
Not so strange.

You can hide protected sheets.

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


Gord


On 9 Oct 2006 13:05:24 -0700, "Mark Lincoln" wrote:

I am able to hide a protected worksheet in Excel 2003. Strange, but
true. :)

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

ToolsProtectionUnProtect Workbook.

You may need to supply a passwrd.

Gord Dibben MS Excel MVP