Help unhide sheets

[sdubose99]

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=1DBE0DO78K00737WJKVNM1EZ1U)

Can anyone offer any suggestions or help?

thank you,
Scot

 

[Guest]

There are no hidden sheets in the workbook.

You have some hidden rows on the current sheet.

 

[Guest]

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]

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

Scott

 

[Guest]

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

Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com

 

[Guest]

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

 

[Guest]

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
(e-mail address removed)
http://www.vonixx.com

 

[sdubose99]

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

Scot

 

[flipo22]

the calculations happen in the hidden columns

 

[flipo22]

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

 

[sdubose99]

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

Scott