Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding and protecting sheet without crashing Excel!
Hi,
I would like to hide a sheet and protect it at the same time. Excel crashes if I use the "hide" menu and then write the following code in the Sub Workbook_Open(): With Worksheets("sheet1") .EnableSelection = xlUnlockedCells .Protect Contents:=True, Password:="xxx", DrawingObjects:=True, UserInterfaceOnly:=True End With Any suggestion? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding and protecting sheet without crashing Excel!
Set the worksheet's .Visible = 2
That will make the sheet "Very" hdden. It won't even show up on th unhide menu. Does that work for you? - Piku -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding and protecting sheet without crashing Excel!
Wonderful! Thanks
-----Original Message----- Set the worksheet's .Visible = 2 That will make the sheet "Very" hdden. It won't even show up on the unhide menu. Does that work for you? - Pikus --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protecting formulas without protecting sheet so grouping still wor | Excel Discussion (Misc queries) | |||
Hiding and protecting formula | Excel Discussion (Misc queries) | |||
Excel 2003 - Protecting and Hiding Columns | Excel Discussion (Misc queries) | |||
Protecting and Hiding formulas | New Users to Excel | |||
Hiding/Protecting vb code in excel | Excel Programming |