how do i hide a single worksheet in a workbook?

[Danie.Bright]

How do i hide a whole worksheet?

i've tried to click on that particular worksheet in a workbook and
hide just it, however it hides the whole workbook. i have a workbook
where people need to see the first 2 worksheets. However the 3rd
worksheet is a database of information that is connected to the first
2 worksheets so it needs to (and i would like it to) stay with the
whole workbook but just hidden so no one messes with it.

is this posisble?

 

[Bob Phillips]

Just goto Format>Sheet>Hide with the appropriate sheet active.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Danie.Bright]

Just goto Format>Sheet>Hide with the appropriate sheet active.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)








- Show quoted text -

thanks a bunch

 

[Guest]

In Excel 2007, you can highlight the sheet/right-click/choose "hide." To
unhide it, highlight the sheets before and after it, right-click, choose
"unhide." Just like hiding/unhiding worksheet rows or columns.

Larry

 

[David Biddulph]

What did it tell you to do when you typed "hide worksheet" into Excel help?
What did you do?

 

[DDavid]

What did it tell you to do when you typed "hide worksheet" into Excel help?
What did you do?

Hi, i have a similar question guys,

Is there a macro that I can Find to hide a specific sheet and unhide
it when necessary ?

Thanks for the help

 

[Gord Dibben]

When would "necessary" take place?

Here is a toggle for hiding/unhiding when a button is clicked or shortcut key
activated.

Sub foo()
With ActiveWorkbook.Sheets("Sheet1")
If .Visible = True Then
..Visible = False
Else: .Visible = True
End If
End With
End Sub


Gord Dibben MS Excel MVP