Hiding sheets
 

Hi,

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



Thanks,


Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=571737

Hiding sheets
 

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


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=571737

Hiding sheets
 

phil2006 Wrote:
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 :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=571737

Hiding sheets
 

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!) ;)


--
carstowal
------------------------------------------------------------------------
carstowal's Profile: http://www.excelforum.com/member.php...o&userid=37476
View this thread: http://www.excelforum.com/showthread...hreadid=571737

Hiding sheets
 

You can hide a sheet and password protect the workbook under
ToolsProtectionProtect 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
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!) ;)