Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have a sheet that I cannot unhide.
I have a sheet that I cannot unhide. In the Visual Basic Editor I can see
that the sheet is there and it has the Visible Property set to '0 - xlSheetHidden'. I have not been able to change the property manually or with code. The other 3 pages are fine. The sheet was built on a Excel 2003 machine and occassionally opened on an Excel 2007 machine. Any ideas why it won't unhide or ideas on how to recover the data? Many thanks in advance. __________ Information from ESET Smart Security, version of virus signature database 4494 (20091009) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have a sheet that I cannot unhide.
Send me a copy. I will try to unhide it.
Dennis "Ted" wrote in message ... I have a sheet that I cannot unhide. In the Visual Basic Editor I can see that the sheet is there and it has the Visible Property set to '0 - xlSheetHidden'. I have not been able to change the property manually or with code. The other 3 pages are fine. The sheet was built on a Excel 2003 machine and occassionally opened on an Excel 2007 machine. Any ideas why it won't unhide or ideas on how to recover the data? Many thanks in advance. __________ Information from ESET Smart Security, version of virus signature database 4494 (20091009) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have a sheet that I cannot unhide.
Try unprotecting the workbook first.
HTH, Barb Reinhardt "Ted" wrote: I have a sheet that I cannot unhide. In the Visual Basic Editor I can see that the sheet is there and it has the Visible Property set to '0 - xlSheetHidden'. I have not been able to change the property manually or with code. The other 3 pages are fine. The sheet was built on a Excel 2003 machine and occassionally opened on an Excel 2007 machine. Any ideas why it won't unhide or ideas on how to recover the data? Many thanks in advance. __________ Information from ESET Smart Security, version of virus signature database 4494 (20091009) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have a sheet that I cannot unhide.
Hi Ted,
If all else fails you might be able to copy the data to a visible sheet with one of the following examples. Sub Macro1() 'Using the sheet given names _ (In parenthesis on project explorer) Sheets("Sheet1").Cells.Copy _ Destination:=Sheets("Sheet2").Range("A1") End Sub Sub Macro2() 'Using the sheet code names _ (NOT in parenthesis on project explorer) Sheet1.Cells.Copy _ Destination:=Sheet2.Range("A1") End Sub -- Regards, OssieMac |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have a sheet that I cannot unhide.
Many thanks to all. The code recovered the data.
"OssieMac" wrote in message ... Hi Ted, If all else fails you might be able to copy the data to a visible sheet with one of the following examples. Sub Macro1() 'Using the sheet given names _ (In parenthesis on project explorer) Sheets("Sheet1").Cells.Copy _ Destination:=Sheets("Sheet2").Range("A1") End Sub Sub Macro2() 'Using the sheet code names _ (NOT in parenthesis on project explorer) Sheet1.Cells.Copy _ Destination:=Sheet2.Range("A1") End Sub -- Regards, OssieMac __________ Information from ESET Smart Security, version of virus signature database 4495 (20091010) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4496 (20091010) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have a sheet that I cannot unhide.
Problem solved. Many thanks to all.
"Ted" wrote in message ... I have a sheet that I cannot unhide. In the Visual Basic Editor I can see that the sheet is there and it has the Visible Property set to '0 - xlSheetHidden'. I have not been able to change the property manually or with code. The other 3 pages are fine. The sheet was built on a Excel 2003 machine and occassionally opened on an Excel 2007 machine. Any ideas why it won't unhide or ideas on how to recover the data? Many thanks in advance. __________ Information from ESET Smart Security, version of virus signature database 4494 (20091009) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4496 (20091010) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4496 (20091010) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent unhide sheet | Excel Worksheet Functions | |||
Hide/Unhide Sheet using VB | Excel Programming | |||
Fed value to unhide rows in another sheet | Excel Programming | |||
HELP!! Unhide Sheet with Macro and focus on other sheet | Excel Discussion (Misc queries) | |||
Can't see sheet, and have tried unhide, etc? | Excel Worksheet Functions |