Hiding sheets

[phil2006]

Hi,

I would like to hide the backup-data sheets in my workbook, is this possible?



Thanks,


Phil

[raypayette]

Yes.
Click Help, write Hide Sheet and you will be offered all the information.

[oldchippy]

Hi,

I would like to hide the backup-data sheets in my workbook, is this possible?



Thanks,


Phil

Hi phil2006,

Try Format > Sheet > Hide

oldchippy

[carsto]

to add to Phils question.

I want to be able to hide the sheet and protect it so that to unhide it requires a password.
But I don't want to protect the entire workbook because others need to add to it.
I haven't found a way to protect some content from others unless I hold it in another workbook and link them. (and unfortunately that simple excel feature is way to much for my boss to deal with!)

[Gord Dibben]

You can hide a sheet and password protect the workbook under
Tools>Protection>Protect Book.

Just be aware that Excel internal passwords are very easy to crack.

You have stated you don't want to protect the workbook so method 2 is another
option.

You could through VB Editor make the sheet xlveryhidden then put password
protection on the VBA project. This password is quite a bit harder to crack.

Sub test()
Worksheets("Sheet1").Visible = xlVeryHidden
' Worksheets("Sheet1").Visible = True
End Sub


Gord Dibben MS Excel MVP


On Tue, 15 Aug 2006 10:27:55 -0400, carstowal
<[email protected]> wrote:

>
>to add to Phils question.
>
>I want to be able to hide the sheet and protect it so that to unhide it
>requires a password.
>But I don't want to protect the entire workbook because others need to
>add to it.
>I haven't found a way to protect some content from others unless I hold
>it in another workbook and link them. (and unfortunately that simple
>excel feature is way to much for my boss to deal with!)