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

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

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

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

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

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