Protection & Grouping
 

Super info! This solved the problem for me and works well with other macro
code. Thanks Dave.

"Dave Peterson" wrote:

I use xl2002 and there's an option to "use Autofilter"--but nothing for
grouping.

You can protect the worksheet in code:

But this setting isn't remembered between closing/reopening the workbook. (So
Auto_open is a nice spot for it.)

Option Explicit
Sub auto_open()

Dim wks As Worksheet
Set wks = Worksheets("sheet1")

With wks
.Protect Password:="hi", userinterfaceonly:=True
.EnableAutoFilter = True
'or
.EnableOutlining = True
End With

End Sub

EnableAutofilter/enableoutlining--depending on what you mean by grouped.

And autofilter or the outlining has to be applied beforehand.

0013 wrote:

Sorry, forgot to mention that I was talking about in 2003.

Even when I check all of the check boxes in the sheet protection dialog, I
still get an error.

Any ideas? Even if it's through VBA?

"Frank Kabel" wrote:

Hi
depending on your Excel version (I think starting in 2003) you can set
these option in the protection dialog

--
Regards
Frank Kabel
Frankfurt, Germany


0013 wrote:
Is there any way to protect a sheet, but still allow people to group
and ungroup rows and columns?

Thanks,



--

Dave Peterson