There's one more option - and as Don mentioned, perhaps you're not intended
to see the sheet and may be better off leaving it alone. But for the daring
soul:

Press [Alt]+[F11] to enter the VB Editor. Choose Insert | Module from the
VBE menu. Copy and paste this code into it:

Sub MakeVeryHiddenJustHidden()
Dim anySheet As Worksheet
For Each anySheet In Worksheets
If anySheet.Visible = xlSheetVeryHidden Then
anySheet.Visible = xlSheetHidden
End If
Next
End Sub

Sub MakeJustHiddenVeryHidden()
Dim anySheet As Worksheet
For Each anySheet In Worksheets
If anySheet.Visible = xlSheetHidden Then
anySheet.Visible = xlSheetVeryHidden
End If
Next
End Sub

Now those 2 macros will be visible in your Tools | Macro | Macros list.
First run the MakeVeryHiddenJustHidden macro. This will turn very hidden
sheets into hidden, but available to be made visible from the Format | Sheets
menu. You can then use that to unhide and look (but not touch?) them.

To reverse the process, take the sheets that you unhid, and put them back
into hidden state and run the MakeJustHiddenVeryHidden macro.

We could have gone from VeryHidden to visible in just one step, but this way
you are forced to acknowledge that you really want to muck around with what
you maybe should not. Also, it would be best to only unhide any hidden ones
one at a time so you can remember which to hide and make totally invisible
again easily.

Your results if the workbook/very hidden worksheets have passwords applied
may vary.


"oldLearner57" wrote:

hi community

can anybody guide this....

when i open a workbook, there is only 1 sheet1 display with data.
and
clicking on, example, a cell and use the Trace Dependent tool, the selected
cell has an Arrow pointing to it. The other cell with the pointer, had a
small icon (squarish shape with gridline & the arrow line is black color with
dash style & at the bottom right side, there is a small black dot)
and
i use the Formula display option, the selected cell has a formula indicating
the data was from sheet2.
however, i tried using the Format Sheet to display the sheet2, but the
command was dimmed.

is it that Sheet2 was hidden and how do i display out the hidden sheet2 ?

the workbook seems not using Macro because i went to the Macro and check,
there is nothing in the Macro dialog box??

hope my explaination is clear

thanks community for the assistance

:)



--
oldLearner57