Record a macro when you do the work.
Then take a look at the notes at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Post back with your questions.
derwood wrote:
could you or someone be kind enough to take me through the process in
doing this
thanks
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.
--
Dave Peterson
--
Dave Peterson