| 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 |
| 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 | |||
Threaded Mode
