Posted to microsoft.public.excel.misc
|
|
show all function with sheet protected
Darn words!
Gord Dibben wrote:
Tewrminology coming into play here<g
My use of "show all" is not correct.
Worksheet is protected with "use autofilter" checked.
Hit drop-down arrow on column A and filter on something.
Hit again on column A drop-down and "All" will unfilter.
Correct that the DataFilterShow All is grayed out.
Gord
On Tue, 25 Jul 2006 10:36:13 -0500, Dave Peterson
wrote:
I use xl2003.
And I couldn't use "show all" on a filtered protected worksheet.
You sure you protected that worksheet when you tested.
(And that's the way I remember xl2002 working, too. But now you're casting
doubts!)
Gord Dibben wrote:
Dave
Is this a 2002 thing?
2003 allows "show all" on a protected sheet.
I can't test because I removed 2002 recently.
Gord Dibben MS Excel MVP
On Tue, 25 Jul 2006 06:48:59 -0500, Dave Peterson
wrote:
The "show all" button is still disabled on a protected worksheet.
You could have your own macro that unprotects the sheet, does a show all, and
then reprotects the sheet, though.
derwood wrote:
hi
thanks for the response but stil desnt work
maybe im doing something wrong basically i want the "show all" button
to work all the time
is it possible it doesnt work in excel v2002
thanks
darren
Gord Dibben wrote:
The Autofilter must be enabled before the sheet is protected.
Then check the "Use Autofilter" option.
Gord Dibben MS Excel MVP
On 24 Jul 2006 18:29:16 -0700, wrote:.
I use the protection with filtering on
is there a way that allows me to have the show all function workable as
this curently is only allowed with the protection off
all assistance is appreciated.
Gord Dibben MS Excel MVP
--
Dave Peterson
|