Worksheet Protection - Allow Detail

F

farutherford

Is there a way I can protect a worksheet that contains a data groupin
(Column D through H) but allow it to be hidden and shown? I want th
sheet protected so the user can enter data only in certain cells. Som
of the data they will edit is kept in a group so it can be hidden fo
ease of use/printing as its not as dynamic as the rest.

Thoughts?

Cheers,
And
 
D

Dave Peterson

If you already have the outlining applied, you can protect the worksheet in code
(auto_open/workbook_open??).

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.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top