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?

Just goto FormatSheetHide with the appropriate sheet active.

--
---
HTH

Bob

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



wrote in message
ps.com...
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?

On Nov 12, 2:03 pm, "Bob Phillips" wrote:
Just goto FormatSheetHide with the appropriate sheet active.

--
---
HTH

Bob

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

wrote in message

ps.com...



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?- Hide quoted text -

- Show quoted text -

thanks a bunch

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



" wrote:

On Nov 12, 2:03 pm, "Bob Phillips" wrote:
Just goto FormatSheetHide with the appropriate sheet active.

--
---
HTH

Bob

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

wrote in message

ps.com...



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?- Hide quoted text -

- Show quoted text -

thanks a bunch

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

wrote in message
ps.com...
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?

On Nov 13, 7:26 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
What did it tell you to do when you typed "hide worksheet" into Excel help?
What did you do?
--
David Biddulph

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



wrote in message

ps.com...

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?

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

On Tue, 13 Nov 2007 12:29:56 -0000, DDavid wrote:

On Nov 13, 7:26 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
What did it tell you to do when you typed "hide worksheet" into Excel help?
What did you do?
--
David Biddulph

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



wrote in message

ps.com...

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?