Hi

I'm not up with these macro's, but do used some off this forum with plenty of
help !

I have spreadsheet with 12 sheets all protected and all with outlines
(grouping) already formated

I am trying to use this macro from Dave Paterson's tread. I have amended the
password and have paste it in "This Workbook"

What I am trying to do, is when the workbook is opened by the operator, they
will be permitted to use the grouping already set up, but still have the
sheet protected. I do have more than one sheet, therefroe will i need to
amend "sheet1" on the first line?

Help appriciated

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="template", userinterfaceonly:=True
.EnableOutlining = True
.EnableAutoFilter = True
End With
End Sub

Using XL 2003

Regards

Brian

--
Message posted via http://www.officekb.com