Hi,

I have preset filters recorded for different status, so at a click of a
button anybody can view pending cases which are at a very high status.
But the buttons do not function when I protect the sheet, even though I
have selected the Enable AutoFilter box.

Is there any code I can enter to unprotect the sheet then protect the
sheet?

Thanks


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=504982

Hi

Create a button on your sheet and apply this code (you will have to insert
your autofilter code)

You will also change sheet1 to the name of the sheet and also password to
your password


private sub commandbutton1_click()

sheets("sheet1").Unprotect = "password"

Autofilter here

sheets("sheet1").Protect = "password"

end sub

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1

Hi harpscardiff

First activate Autofilter and then protect your sheet with the filter option checked

--
Regards Ron de Bruin
http://www.rondebruin.nl


"harpscardiff" wrote in message
news:harpscardiff.227aja_1138209602.7846@excelforu m-nospam.com...

Hi,

I have preset filters recorded for different status, so at a click of a
button anybody can view pending cases which are at a very high status.
But the buttons do not function when I protect the sheet, even though I
have selected the Enable AutoFilter box.

Is there any code I can enter to unprotect the sheet then protect the
sheet?

Thanks


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=504982

If I not understand you correct see
http://www.contextures.com/xlautofilter03.html#Protect


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Hi harpscardiff

First activate Autofilter and then protect your sheet with the filter option checked

--
Regards Ron de Bruin
http://www.rondebruin.nl


"harpscardiff" wrote in message
news:harpscardiff.227aja_1138209602.7846@excelforu m-nospam.com...

Hi,

I have preset filters recorded for different status, so at a click of a
button anybody can view pending cases which are at a very high status.
But the buttons do not function when I protect the sheet, even though I
have selected the Enable AutoFilter box.

Is there any code I can enter to unprotect the sheet then protect the
sheet?

Thanks


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=504982

I understand what you guys are saying - but I have 4 different filters.

1 - turns filters on and off
2 - Shows pending records
3 - shows TBA records
4 - shows very high/high pending records.

I can't turn them all on, then protect.....do I have to amend the code
if so how?

Thank

--
harpscardif
-----------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...fo&userid=2596
View this thread: http://www.excelforum.com/showthread.php?threadid=50498