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.