Protcting a worksheet with a filter
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 |
Protcting a worksheet with a filter
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 |
Protcting a worksheet with a filter
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 |
Protcting a worksheet with a filter
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 |
Protcting a worksheet with a filter
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 |
All times are GMT +1. The time now is 04:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com