Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot hide a sheet in a workbook. Why?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One workbook to another . . . | Excel Discussion (Misc queries) | |||
Hide sheet in workbook | Excel Worksheet Functions | |||
CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
Use Sheet CodeNames to Select Sheet in Different Workbook | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |