Protected worksheet, showing and hiding Grouped detail

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?

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

Colin_Bizfine wrote:
>
> 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

Thanks Dave, I will give that a try

"Dave Peterson" wrote:

> 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
>
> Colin_Bizfine wrote:
> >
> > 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
>

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

"Colin_Bizfine" wrote:

> Thanks Dave, I will give that a try
>
> "Dave Peterson" wrote:
>
> > 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
> >
> > Colin_Bizfine wrote:
> > >
> > > 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
> >

Glad it worked for you.

Colin_Bizfine wrote:
>
> Tried it. Dave, you are an absolute genius - works exactly as I wanted.
> Many Thanks!
>
> "Colin_Bizfine" wrote:
>
> > Thanks Dave, I will give that a try
> >
> > "Dave Peterson" wrote:
> >
> > > 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
> > >
> > > Colin_Bizfine wrote:
> > > >
> > > > 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
> > >

--

Dave Peterson