hidden worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

:)
 
Check If the Worksheet is Protected. . You will need a password to unprotect it
Tools - Protection - unprotect sheets
 
Perhaps the author hid the macros that made the sheet veryhidden. Maybe you
are not authorized.
 
TheFormatSheet>Unhide will become available if you remove Workbook Protection
from Tools>Protection>Unprotect Workbook.

That's workbook.................not worksheet.


Gord Dibben MS Excel MVP
 
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.
 
If he is not intended why are you helping him???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
JLatham said:
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 said:
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

:)
Click to expand...
Click to expand...
 
I figure he's a big boy and can fend for himself should he knowingly walk
into a marked mine-field. Such ventures can be teaching/learning experiences
to some.

No worse, in my view, of pointing out places to obtain password
revealing/cracking tools for Excel workbooks/worksheets.

Don Guillett said:
If he is not intended why are you helping him???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
JLatham said:
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 said:
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

:)
Click to expand...
Click to expand...
Click to expand...
 
P.S. My manners escaped me for a moment! Congratulations on MVP - the
knowledge you have and share certainly merits the award.

Don Guillett said:
If he is not intended why are you helping him???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
JLatham said:
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 said:
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

:)
Click to expand...
Click to expand...
Click to expand...
 
I don't give out that info either.
Thanks for the congrats on MVP. It is appreciated.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
JLatham said:
I figure he's a big boy and can fend for himself should he knowingly walk
into a marked mine-field. Such ventures can be teaching/learning
experiences
to some.

No worse, in my view, of pointing out places to obtain password
revealing/cracking tools for Excel workbooks/worksheets.

Don Guillett said:
If he is not intended why are you helping him???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
JLatham said:
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.


:

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

:)
Click to expand...
Click to expand...
Click to expand...
 
thanks JLatham for the procedure on how to see the "hidden" sheet and rest
assure that the request for "how to display the hidden" sheet is merely a
tutorial project and has no ill intention :)

thanks community as well :)
--
oldLearner57


JLatham said:
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 said:
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

:)
Click to expand...
Click to expand...
 
thanks :) Don Guillett for the guidance given and rest assure that the
request for "how to display the hidden" sheet is merely a tutorial project
and has no ill intention :)

thanks community as well :)
--
oldLearner57


Don Guillett said:
I don't give out that info either.
Thanks for the congrats on MVP. It is appreciated.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
JLatham said:
I figure he's a big boy and can fend for himself should he knowingly walk
into a marked mine-field. Such ventures can be teaching/learning
experiences
to some.

No worse, in my view, of pointing out places to obtain password
revealing/cracking tools for Excel workbooks/worksheets.

Don Guillett said:
If he is not intended why are you helping him???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
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.


:

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

:)
Click to expand...
Click to expand...
Click to expand...
 
Back
Top