Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I protect a range but allow auto filtering in earlier versi
I created a s.s. that needs to be protected from anyone changing it but
anyone needs to be able to use the auto filter. I created it in 2007, saved as earlier version. I picked allow users to select unlocked cells and use the auto filter but it still doesn't work except in 2007. So, how would I protect the sheet and be able to use the auto filter in earlier versions? -- Gracie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I protect a range but allow auto filtering in earlier versi
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, but that won't help when you're filtering via code.) Graciegirl wrote: I created a s.s. that needs to be protected from anyone changing it but anyone needs to be able to use the auto filter. I created it in 2007, saved as earlier version. I picked allow users to select unlocked cells and use the auto filter but it still doesn't work except in 2007. So, how would I protect the sheet and be able to use the auto filter in earlier versions? -- Gracie -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto filtering? | Excel Worksheet Functions | |||
Incompatible "allow users to edit range" in earlier Excel versions | Excel Discussion (Misc queries) | |||
Excel functions names should be in English for all Localized versi | Excel Worksheet Functions | |||
Excel auto filtering to find a range of dates in a list | Excel Discussion (Misc queries) | |||
Count the number of dates in a range that are earlier than today. | Excel Worksheet Functions |