show all function with sheet protected

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.

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



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

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

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, [email protected] 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

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, [email protected] 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

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, [email protected] 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

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

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 <[email protected]>
> 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, [email protected] 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

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


On Tue, 25 Jul 2006 10:36:13 -0500, Dave Peterson <[email protected]>
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 <[email protected]>
>> 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, [email protected] 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

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 Data>Filter>Show All is grayed out.
>
> Gord
>
> On Tue, 25 Jul 2006 10:36:13 -0500, Dave Peterson <[email protected]>
> 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 <[email protected]>
> >> 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, [email protected] 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