Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide a Sheet Q
I thought the XLVeryhidden function hides a sheet from been unhidden
via Format-Sheet-Unhide and could only be unhidden via code. Does the Workbook or Sheet have to be protected also? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide a Sheet Q
Sean,
With this code and no Protection: Private Sub CommandButton1_Click() Worksheets(2).Visible = xlVeryHidden Worksheets(3).Visible = xlHidden End Sub I only see Worksheet 3 in the list of FormatSheetUnhide. I the use run suitable code, then can unhide Worksheet 3 though. NickHK "Sean" wrote in message ups.com... I thought the XLVeryhidden function hides a sheet from been unhidden via Format-Sheet-Unhide and could only be unhidden via code. Does the Workbook or Sheet have to be protected also? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide a Sheet Q
That should read:
"If the user runs suitable code, they can unhide Worksheet 2 though." NickHK "NickHK" wrote in message ... Sean, With this code and no Protection: Private Sub CommandButton1_Click() Worksheets(2).Visible = xlVeryHidden Worksheets(3).Visible = xlHidden End Sub I only see Worksheet 3 in the list of FormatSheetUnhide. I the use run suitable code, then can unhide Worksheet 3 though. NickHK "Sean" wrote in message ups.com... I thought the XLVeryhidden function hides a sheet from been unhidden via Format-Sheet-Unhide and could only be unhidden via code. Does the Workbook or Sheet have to be protected also? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide a Sheet Q
Thanks Nick
I had this code for Worksheet open Worksheets(1).Visible = False Having already xlVeryhidden all sheets except for one when closing. When I opened the worksheet was not aware that the above would overide and hence not be visible but show the sheet in Format-Sheet-Unhide On Jan 30, 8:31 am, "NickHK" wrote: Sean, With this code and no Protection: Private Sub CommandButton1_Click() Worksheets(2).Visible = xlVeryHidden Worksheets(3).Visible = xlHidden End Sub I only see Worksheet 3 in the list of FormatSheetUnhide. I the use run suitable code, then can unhide Worksheet 3 though. NickHK "Sean" wrote in oglegroups.com... I thought the XLVeryhidden function hides a sheet from been unhidden via Format-Sheet-Unhide and could only be unhidden via code. Does the Workbook or Sheet have to be protected also? Thanks- Hide quoted text -- Show quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide a Sheet Q
Sean,
Checking the values of the settings in the Immediate window gives: ?xlsheethidden 0 ?xlsheetveryhidden 2 ?xlSheetVisible -1 So you can see the 2 lines of code are exactly the same: Worksheets(1).Visible = False Worksheets(1).Visible = xlSheetHidden NickHK "Sean" wrote in message ps.com... Thanks Nick I had this code for Worksheet open Worksheets(1).Visible = False Having already xlVeryhidden all sheets except for one when closing. When I opened the worksheet was not aware that the above would overide and hence not be visible but show the sheet in Format-Sheet-Unhide On Jan 30, 8:31 am, "NickHK" wrote: Sean, With this code and no Protection: Private Sub CommandButton1_Click() Worksheets(2).Visible = xlVeryHidden Worksheets(3).Visible = xlHidden End Sub I only see Worksheet 3 in the list of FormatSheetUnhide. I the use run suitable code, then can unhide Worksheet 3 though. NickHK "Sean" wrote in oglegroups.com... I thought the XLVeryhidden function hides a sheet from been unhidden via Format-Sheet-Unhide and could only be unhidden via code. Does the Workbook or Sheet have to be protected also? Thanks- Hide quoted text -- Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Sheet, Hide Sheet | Excel Discussion (Misc queries) | |||
Hide Sheet If.... | Excel Programming | |||
hide sheet | Excel Programming | |||
hide sheet? uncheck sheet tabs? or ??? | Excel Programming | |||
Hide Sheet | Excel Programming |