Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Protection
HI!
I want to let the users utilize the Outline-possibility in a protected sheet. Is there an easy way round the fact that a protected sheet does not allow? regards, Tor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Protection
If you protect the sheet in code (auto_open/workbook_open??), you can allow
this: Option Explicit Sub auto_open() With Worksheets("sheet1") .Protect Password:="hi", userinterfaceonly:=True .EnableOutlining = True End With End Sub It needs to be reset each time you open the workbook. (excel doesn't remember it after closing the workbook.) (you could use the workbook_open even under ThisWorkbook, too.) Don't forget to lock the VBA Project, too. Else you'll have inquisitive types looking at your code and seeing the password. Inside the VBE, you can lock the project. Tools|VBAProject Properties|Protection tab. Give it a memorable password and lock the project for viewing. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Tor wrote: HI! I want to let the users utilize the Outline-possibility in a protected sheet. Is there an easy way round the fact that a protected sheet does not allow? regards, Tor -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet protection | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Worksheet protection | Excel Discussion (Misc queries) | |||
Worksheet Protection | Excel Discussion (Misc queries) |