PDA

View Full Version : Unhide hidden sheet?



evek
10-03-2010, 09:50 AM
I have Excel file where 6 sheets and 1 more named MASTER is hided.
I tried to do it from menue (Excel 2003 and Excel 2007) Format -> Sheet -> Unhide , but Unhide option there is not active.
How I can to see data on MASTER sheet?

Bob Phillips
10-03-2010, 10:15 AM
Go to the VBIDE (Alt-F11) and in the immediate window try

Worksheets("MASTER").Visible = xlSheetVisible

evek
10-03-2010, 10:23 AM
it gives error -- see attached pic

Bob Phillips
10-03-2010, 11:05 AM
Can you post that workbook?

Paul_Hossler
10-03-2010, 01:13 PM
Is the workbook protected?

Paul

Aussiebear
10-03-2010, 06:42 PM
Why not just go to the Properties window and change the visibility option

Simon Lloyd
10-04-2010, 12:06 AM
Is the workbook protected?

PaulPaul is correct you would only get that if the workbook structure is protected, it doesn't matter if the sheetname is in upper or lower case, go to tools>protection>unprotect workbook.