Hidden sheets

[FGOMEZ]

I have inherited a spreadsheet from a co-worker, that apparently has some
hidden sheets, but I can not find them trhu "Format=>Sheets=>Unhide" Menu
the file was protected but I removed it, so now is unprotected.
I can see formulas that refers to sheets I can not see.
I have also unprotected the workbook.
Could somebody help me, with this issue.

Thanks

Fernando

[Sandy Mann]

Perhaps it has been hidden to xlveryhidden in code. Try running:

Sub UnHideIt()
For x = 1 To Sheets.Count
Sheets(x).Visible = True
Next x

End Sub

(After backing uo you sheet of course)

Regards



"FGOMEZ" <[email protected]> wrote in message
news:[email protected]...
> I have inherited a spreadsheet from a co-worker, that apparently has some
> hidden sheets, but I can not find them trhu "Format=>Sheets=>Unhide" Menu
> the file was protected but I removed it, so now is unprotected.
> I can see formulas that refers to sheets I can not see.
> I have also unprotected the workbook.
> Could somebody help me, with this issue.
>
> Thanks
>
> Fernando
>
>

[Dave Peterson]

Maybe you could run a little macro:

Option Explicit
Sub testme()

Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
wks.Visible = xlSheetVisible
Next wks

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

FGOMEZ wrote:
>
> I have inherited a spreadsheet from a co-worker, that apparently has some
> hidden sheets, but I can not find them trhu "Format=>Sheets=>Unhide" Menu
> the file was protected but I removed it, so now is unprotected.
> I can see formulas that refers to sheets I can not see.
> I have also unprotected the workbook.
> Could somebody help me, with this issue.
>
> Thanks
>
> Fernando

--

Dave Peterson

[FGOMEZ]

Thanks Sandy, but now I have another problem I got an error message saying
"Compiled Error" Variable not defined anmd stop in x, How do you fix this.

Thanks


"Sandy Mann" <[email protected]> wrote in message
news:[email protected]...
> Perhaps it has been hidden to xlveryhidden in code. Try running:
>
> Sub UnHideIt()
> For x = 1 To Sheets.Count
> Sheets(x).Visible = True
> Next x
>
> End Sub
>
> (After backing uo you sheet of course)
>
> Regards
>
>
>
> "FGOMEZ" <[email protected]> wrote in message
> news:[email protected]...
> > I have inherited a spreadsheet from a co-worker, that apparently has
some
> > hidden sheets, but I can not find them trhu "Format=>Sheets=>Unhide"
Menu
> > the file was protected but I removed it, so now is unprotected.
> > I can see formulas that refers to sheets I can not see.
> > I have also unprotected the workbook.
> > Could somebody help me, with this issue.
> >
> > Thanks
> >
> > Fernando
> >
> >
>
>

[Harald Staff]

Put
Dim x As Long
before the line
For x =

HTH. Best wishes Harald

"FGOMEZ" <[email protected]> skrev i melding
news:%[email protected]...
> Thanks Sandy, but now I have another problem I got an error message saying
> "Compiled Error" Variable not defined anmd stop in x, How do you fix this.
>
> Thanks
>
>
> "Sandy Mann" <[email protected]> wrote in message
> news:[email protected]...
> > Perhaps it has been hidden to xlveryhidden in code. Try running:
> >
> > Sub UnHideIt()
> > For x = 1 To Sheets.Count
> > Sheets(x).Visible = True
> > Next x
> >
> > End Sub
> >
> > (After backing uo you sheet of course)
> >
> > Regards
> >
> >
> >
> > "FGOMEZ" <[email protected]> wrote in message
> > news:[email protected]...
> > > I have inherited a spreadsheet from a co-worker, that apparently has
> some
> > > hidden sheets, but I can not find them trhu "Format=>Sheets=>Unhide"
> Menu
> > > the file was protected but I removed it, so now is unprotected.
> > > I can see formulas that refers to sheets I can not see.
> > > I have also unprotected the workbook.
> > > Could somebody help me, with this issue.
> > >
> > > Thanks
> > >
> > > Fernando
> > >
> > >
> >
> >
>
>