show all function with sheet protected

T

tcob01

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.
 
G

Gord Dibben

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, [email protected] wrote:.
 
D

derwood

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
 
D

Dave Peterson

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.
 
D

derwood

could you or someone be kind enough to take me through the process in
doing this

thanks
 
G

Gord Dibben

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
 
D

Dave Peterson

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!)
 
G

Gord Dibben

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 Data>Filter>Show All is grayed out.


Gord


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!)
Click to expand...

Gord Dibben MS Excel MVP
 
D

Dave Peterson

Darn words!

Gord said:
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 Data>Filter>Show All is grayed out.

Gord



Gord Dibben MS Excel MVP
Click to expand...
 
Top