Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!) ;) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding sheets within a workbook | Charts and Charting in Excel | |||
Hiding sheets - Impact on Speed | Excel Discussion (Misc queries) | |||
Hiding and unhiding sheets | Excel Discussion (Misc queries) | |||
Locking Sheets / Hiding Sheets | Excel Worksheet Functions | |||
Protection and Hiding Sheets | Excel Discussion (Misc queries) |