Protected worksheet, showing and hiding Grouped detail

[Guest]

I have column data that is grouped. When I apply protection to the worksheet
it is not possible to show hidden columns or hide displayed columns.
I want users to be able to do this so that they can adjust the detail that
is printed for their own purposes but I want the content of the sheet
protected.
Is there any way to do this?

 

[Dave Peterson]

If you already have the outline 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

 

[Guest]

Thanks Dave, I will give that a try

If you already have the outline 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

 

[Guest]

Tried it. Dave, you are an absolute genius - works exactly as I wanted.
Many Thanks!

 

[Dave Peterson]

Glad it worked for you.

Tried it. Dave, you are an absolute genius - works exactly as I wanted.
Many Thanks!