Question regarding Filtering in a protected worksheet

[knash]

I have a worksheet that is all protected except columns A and B. This
spreadsheet is for updating different buyers their shipping cost.

I would like for the buyer to be able to update columns A & B as
needed for their specific jobs (This part I got). However, the jobs
are listed by date and cost and there are over 1000 different jobs on
the spreadsheet. The buyers need to be able to filter by their name
so they can see their jobs only. Is it possible to filter on the two
unprotected columns? or on all of the columns while the spreadsheet is
protected?

Thanks!

Kris

 

[Frank Kabel]

Hi
see:
http://www.contextures.com/xlautofilter03.html#Protect

 

[knash]

Okay...so it is probably user error, but...

I am using excel 2000. I entered the provided code(see below) and i
get a Run-time error '9': Subscript out of range.

Code:

Private Sub Workbook_Open()
'check for filter, turn on if none exists
With Worksheets("Data")
If Not .AutoFilterMode Then
.Range("A1").AutoFilter
End If
.EnableAutoFilter = True
.Protect Password:="password", _
Contents:=True, UserInterfaceOnly:=True
End With
End Sub

What am i doing wrong???

Thanks again for your help!

Kris

 

[Frank Kabel]

Hi
in which line do you get this error?. Also have you checked that your
worksheet is named 'Data'