Protcting a worksheet with a filter

[The BriGuy]

I have a worksheet with filters on several columns. Does anyone know of a
way to protect the entire sheet so other scannot make changes to data and
also allow the auto-filter to work so data can still be filtered as needed?

Thanks

 

[John Bundy]

When you go to Tools->Protection->Protect sheet as you normally would to
protect a sheet, there is a Use Autofilter checkbox neat the bottom. xl2003

 

[The BriGuy]

Thanks but I'm using the 2000 version and don't have that option available to
me.

 

[The BriGuy]

Thanks but I'm using the 2000 version and don't have that option available to
me.

 

[Dave Peterson]

If you already have the outline/subtotals/autofilter 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
.EnableAutoFilter = True
'If .FilterMode Then
' .ShowAllData
'End If
End With
End Sub

It needs to be reset each time you open the workbook. (Earlier versions of
excel don't remember it after closing the workbook. IIRC, xl2002+ will remember
the allow autofilter setting under tools|Protection|protect sheet.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm