View Full Version : Unhide hidden sheet?
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
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.