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

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
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"The BriGuy" wrote:

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

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

"John Bundy" wrote:

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
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"The BriGuy" wrote:

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

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

"John Bundy" wrote:

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
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"The BriGuy" wrote:

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

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

The BriGuy wrote:

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

--

Dave Peterson