Enabling outline and level functions on a protected worksheet?

E

eanndem

Is there a was to preserve the outline/level functions on a protected
worksheet?

None of the "allow all users to..." elements seem to affect this feature.
When protecting a worksheet is necessary for locking certain formula cells,
the outline/level functions become inoperative. I have been unable to find
the answer in help screens, etc.

Does anyone have the key to this mystery?
 
A

Anne Troy

More than likely, you will need to make a VBA Solution. This will require
making macros to unprotect the sheet, perform the action, then reprotect the
sheet. You will want to provide a custom toolbar from which the users can
perform those actions. You may want to re-word and re-ask your question in
the excel.programming newsgroup.
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
www.Brainbench.com Word Test Developer 2000,2002,2003
********************************
 
D

Debra Dalgleish

If you protect the worksheet programmatically, you can enable outlining,
and you will be able to use the groups that you have created.

Copy the following code, and paste it in the ThisWorkbook module
(Alt+F11 will open the Visual Basic Editor).
Change the sheet name to refer to the sheet in your workbook:

Private Sub Workbook_Open()
With Worksheets("Sheet1")
.EnableOutlining = True
.Protect Password:="password", _
Contents:=True, UserInterfaceOnly:=True
End With

End Sub
 
Top