Have your code unprotect the sheet, showall, reprotect the sheet.

--
Regards,
Tom Ogilvy

"Gareth Surgenor" wrote in message
om...
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