Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel will not "show all" from an Advanced Filter on a sheet with protected cells.
Hi all,
I'm a group newbie so apologies in advance for any faux pas! Question: I have a worksheet with an advanced filter operating on it, and I want to protect cells by password. Using the normal routes for protection I've allowed access to the cells I want to be editable and all is fine, except....... My advanced filter is controlled by 2 commandbuttons I've put ont the form, "filter" and "show all" as the sheet is to be used by computer users non technicals. The filter button works fine when the sheet is protected, but the "advanced filter show all" button hangs with error "Showalldata method of worksheet class failed", and highlights the line of code "Activesheet ShowAllData" attached to that button in Vb. This results in my data not being unfiltered, and Vb pops up, scaring the above mentioned users. I've used the line "On Error Resume Next" to cover the error and stop Vb coming up, but I can't "show all" until I unprotect the sheet! Is there anyway I can allow an advanced filter show all on a protected sheet? I've tried using the "activesheet.enableautofilter = true", but this doesn't work for advanced filters. Grr. Any ideas, your help is much appreciated. Yours, Gareth Surgenor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
sheet protected but cells "cleared of all" become locked | Excel Discussion (Misc queries) | |||
"Live" Advanced Filter (for unique records) | Excel Discussion (Misc queries) | |||
Advanced filter formula for "contains="Sept" | Excel Worksheet Functions | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) |