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.

show all function with sheet protected
 

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.

show all function with sheet protected
 

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.

show all function with sheet protected
 

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

show all function with sheet protected
 

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

show all function with sheet protected
 

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

show all function with sheet protected
 

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.

show all function with sheet protected
 

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.

--

Dave Peterson

show all function with sheet protected
 

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

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