Help unhide sheets
 

Hi there... I'm not an expert and got into a mess with one of my files.
I intentionally hid certain sheets but now can't unhide them. I'v
unprotected my workbook, gone into VBA but can't see the other sheet
to unhide them. There should be one other sheet called 'Constants'.

I've uploaded the file 'here
(http://s32.yousendit.com/d.aspx?id=1...737WJKVNM1EZ1U)

Can anyone offer any suggestions or help?

thank you,
Scot

--
sdubose9
-----------------------------------------------------------------------
sdubose99's Profile: http://www.excelforum.com/member.php...fo&userid=2753
View this thread: http://www.excelforum.com/showthread.php?threadid=53298

Help unhide sheets
 

There are no hidden sheets in the workbook.

You have some hidden rows on the current sheet.

--
Regards,
Tom Ogilvy



"sdubose99" wrote:


Hi there... I'm not an expert and got into a mess with one of my files.
I intentionally hid certain sheets but now can't unhide them. I've
unprotected my workbook, gone into VBA but can't see the other sheets
to unhide them. There should be one other sheet called 'Constants'.

I've uploaded the file 'here '
(http://s32.yousendit.com/d.aspx?id=1...737WJKVNM1EZ1U)

Can anyone offer any suggestions or help?

thank you,
Scott


--
sdubose99
------------------------------------------------------------------------
sdubose99's Profile: http://www.excelforum.com/member.php...o&userid=27538
View this thread: http://www.excelforum.com/showthread...hreadid=532981

Help unhide sheets
 

Perhaps the sheets visible property got changed to X1VeryHidden. If that is
the case you can only unhide the sheet using a macro. Format / Sheet /
Unhide won't work in that case.

"sdubose99" wrote:


Hi there... I'm not an expert and got into a mess with one of my files.
I intentionally hid certain sheets but now can't unhide them. I've
unprotected my workbook, gone into VBA but can't see the other sheets
to unhide them. There should be one other sheet called 'Constants'.

I've uploaded the file 'here '
(http://s32.yousendit.com/d.aspx?id=1...737WJKVNM1EZ1U)

Can anyone offer any suggestions or help?

thank you,
Scott


--
sdubose99
------------------------------------------------------------------------
sdubose99's Profile: http://www.excelforum.com/member.php...o&userid=27538
View this thread: http://www.excelforum.com/showthread...hreadid=532981

Help unhide sheets
 

Thank you very much for the replies -- can you or someone suggest a
macro to accomplish that?

Scott


--
sdubose99
------------------------------------------------------------------------
sdubose99's Profile: http://www.excelforum.com/member.php...o&userid=27538
View this thread: http://www.excelforum.com/showthread...hreadid=532981

Help unhide sheets
 

In that Excel file, there is absolutely no hidden sheet. There is one and
only one worksheet (, and nothing is "xlveryhidden").

Regards,
Edwin Tam

http://www.vonixx.com


"William Horton" wrote:

Perhaps the sheets visible property got changed to X1VeryHidden. If that is
the case you can only unhide the sheet using a macro. Format / Sheet /
Unhide won't work in that case.

"sdubose99" wrote:


Hi there... I'm not an expert and got into a mess with one of my files.
I intentionally hid certain sheets but now can't unhide them. I've
unprotected my workbook, gone into VBA but can't see the other sheets
to unhide them. There should be one other sheet called 'Constants'.

I've uploaded the file 'here '
(http://s32.yousendit.com/d.aspx?id=1...737WJKVNM1EZ1U)

Can anyone offer any suggestions or help?

thank you,
Scott


--
sdubose99
------------------------------------------------------------------------
sdubose99's Profile: http://www.excelforum.com/member.php...o&userid=27538
View this thread: http://www.excelforum.com/showthread...hreadid=532981

Help unhide sheets
 

There are no hidden sheets. I used a macro.

here is is:

Sub abc()
For Each sh In ActiveWorkbook.Sheets
sh.Visible = xlSheetVisible
Next
End Sub

--
Regards,
Tom Ogilvy


"sdubose99" wrote:


Thank you very much for the replies -- can you or someone suggest a
macro to accomplish that?

Scott


--
sdubose99
------------------------------------------------------------------------
sdubose99's Profile: http://www.excelforum.com/member.php...o&userid=27538
View this thread: http://www.excelforum.com/showthread...hreadid=532981

Help unhide sheets
 

If you merely want to unhide all sheets, you can try:

Sub unhide_sheets()
Dim a As Object
For Each a In ActiveWorkbook.Sheets
a.Visible = True
Next
End Sub

But, if you apply the macro to the file you posted for us, you'll not find
the sheet called "constants" that you mentioned...

Regards,
Edwin Tam

http://www.vonixx.com


"sdubose99" wrote:


Thank you very much for the replies -- can you or someone suggest a
macro to accomplish that?

Scott


--
sdubose99
------------------------------------------------------------------------
sdubose99's Profile: http://www.excelforum.com/member.php...o&userid=27538
View this thread: http://www.excelforum.com/showthread...hreadid=532981

Help unhide sheets
 

There is a hidden "data" sheet doing all the behind the scene
calculations and feeding the front sheet.

Scot

--
sdubose9
-----------------------------------------------------------------------
sdubose99's Profile: http://www.excelforum.com/member.php...fo&userid=2753
View this thread: http://www.excelforum.com/showthread.php?threadid=53298

Help unhide sheets
 

the calculations happen in the hidden columns

sdubose99 wrote:
There is a hidden "data" sheet doing all the behind the scene
calculations and feeding the front sheet.

Scot

Help unhide sheets
 

There is no hidden sheet at all !

Highlight the J and AF Columns
Go to Format , Columns, Width, then write 17,29 and click OK

Then you see your formulas and graph

Help unhide sheets
 

What a doofus I am! I started with additional sheets... sorry to put
y'all through this.

Scott


--
sdubose99
------------------------------------------------------------------------
sdubose99's Profile: http://www.excelforum.com/member.php...o&userid=27538
View this thread: http://www.excelforum.com/showthread...hreadid=532981