I have a sheet that I cannot unhide.

[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

 

[Dennis Tucker]

Send me a copy. I will try to unhide it.

Dennis

 

[Barb Reinhardt]

Try unprotecting the workbook first.

HTH,
Barb Reinhardt

 

[OssieMac]

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

 

[Ted]

Many thanks to all. The code recovered the data.

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

 

[Ted]

Problem solved. Many thanks to all.

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