I have a sheet that I cannot unhide.

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

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
 
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
 
Many thanks to all. The code recovered the data.
OssieMac said:
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
Click to expand...


__________ Information from ESET Smart Security, version of virus signature database 4496 (20091010) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Problem solved. Many thanks to all.

Ted said:
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
Click to expand...


__________ Information from ESET Smart Security, version of virus signature database 4496 (20091010) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top