Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
Is it possible to past objects on protected sheet via linking? | Excel Discussion (Misc queries) | |||
How to paste objects in a protected sheet | Excel Discussion (Misc queries) | |||
Function that will copy sheet to sheet IF... | Excel Worksheet Functions | |||
custom function not recalcing on sheet with outline view | Excel Worksheet Functions |