Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using auto filter after my worksheet is protected
After I have protected my worksheet, i can't go to DataFliterShow all
function doesn't work. is there any way i can just the show all function even my worksheet is protected? -- LY |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using auto filter after my worksheet is protected
Which Excel version do you use?
-- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "LY" wrote: After I have protected my worksheet, i can't go to DataFliterShow all function doesn't work. is there any way i can just the show all function even my worksheet is protected? -- LY |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using auto filter after my worksheet is protected
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.) LY wrote: After I have protected my worksheet, i can't go to DataFliterShow all function doesn't work. is there any way i can just the show all function even my worksheet is protected? -- LY -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use auto filter in a protected worksheet | Excel Discussion (Misc queries) | |||
Help with using Auto-filter in a protected Worksheet. | Excel Discussion (Misc queries) | |||
Using Hide, Unhide, and auto filter - select all on a protected sh | Excel Worksheet Functions | |||
Auto Filter with Protected Worksheet | Excel Worksheet Functions | |||
Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) |