Hiding sheets

P

phil2006

Hi,

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



Thanks,


Phil
 
O

oldchippy

phil2006 said:
Hi,

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



Thanks,


Phil
Click to expand...

Hi phil2006,

Try Format > Sheet > Hide

oldchippy :)
 
C

carstowal

to add to Phils question.

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

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
 
Top