How to make hidden sheet invisible

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LLee2 - 06 Apr 2007 17:16 GMT

Does anyone know how to make a hidden sheet invisible?

Thanks,
llee2

Reply to this Message

Dave Peterson - 06 Apr 2007 17:39 GMT

Isn't a hidden sheet already not visible?

You could go into the VBE and change its .visible property to xlsheetveryhidden.

Did you mean that?

This would make it so that the sheet name didn't show up under
Format|Sheet|Unhide

That's about the only difference.

> Does anyone know how to make a hidden sheet invisible?
>
> Thanks,
> llee2

Signature

Dave Peterson

Reply to this Message

daregreatly - 06 Apr 2007 17:52 GMT

> Does anyone know how to make a hidden sheet invisible?
>
> Thanks,
> llee2

I think you need VBA...

Make a new workbook with 2 or more sheets...
Key Alt-F11
Insert a Module
Copy the following code there... and hit F5

Sub HideOne()
'run this on a new workbook with 2 sheets
this1 = Sheets(1).Name
Sheets(1).Tab.ColorIndex = 3
Sheets(2).Activate

resp = MsgBox("Hide First Sheet?", vbOKOnly)
Sheets(this1).Visible = xlSheetHidden

resp = MsgBox("Hide it TOTALLY?" & Chr(10) & "Not visible under Format-

>Sheet->Unhide", vbYesNo)

If resp = vbYes Then
Sheets(this1).Visible = xlSheetVeryHidden
End If

resp = MsgBox("Bring it back?", vbYesNo)
If resp = vbYes Then
Sheets(this1).Visible = xlSheetVisible
End If

End Sub

Reply to this Message

JMB - 07 Apr 2007 03:02 GMT

It could also be done w/o VBA. Click View/Toolbars/Control Toolbox. Click
the properties button and change the visible property there.

Of course, if changed to very hidden - I believe the OP will need to use VBA
to unhide the sheet.

> > Does anyone know how to make a hidden sheet invisible?
> >
[quoted text clipped - 28 lines]
>
> End Sub

Reply to this Message

Dave Peterson - 07 Apr 2007 03:24 GMT

Or go through the VBE and change the properties in the property window (with
that worksheet object selected in the project explorer window).

> It could also be done w/o VBA. Click View/Toolbars/Control Toolbox. Click
> the properties button and change the visible property there.
[quoted text clipped - 34 lines]
> >
> > End Sub

Signature

Dave Peterson

Reply to this Message

JMB - 07 Apr 2007 03:32 GMT

I thought that was what you were getting at w/your first post.

> Or go through the VBE and change the properties in the property window (with
> that worksheet object selected in the project explorer window).
[quoted text clipped - 37 lines]
> > >
> > > End Sub

Reply to this Message

Dave Peterson - 07 Apr 2007 14:12 GMT

It was.

I was trying to emphasize that you don't actually need VBA to unhide a very
hidden sheet. (I don't count going to the VBE as using code.)

> I thought that was what you were getting at w/your first post.
>
[quoted text clipped - 43 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

JMB - 07 Apr 2007 18:30 GMT

Sorry - of course if it can be hidden w/the VBE it can be unhidden. Looks
like I picked a bad week to stop sniffing glue.

> It was.
>
[quoted text clipped - 48 lines]
> > >
> > > Dave Peterson

Reply to this Message

Dave Peterson - 07 Apr 2007 19:27 GMT

Just in case...

http://www.imdb.com/title/tt0080339/

> Sorry - of course if it can be hidden w/the VBE it can be unhidden. Looks
> like I picked a bad week to stop sniffing glue.
[quoted text clipped - 55 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

JMB - 08 Apr 2007 06:58 GMT

<g> I didn't know that was from 1980. I thought it more mid to late 80's.
Time flies when your memory sucks.

> Just in case...
>
[quoted text clipped - 59 lines]
> > >
> > > Dave Peterson

Reply to this Message