Good afternoon Duncan Help
Probably nothing. If you are using Excel 2002 or later you can set the
options when you turn on the protection whether or not to allow the
filters to operate.
If you are using XL2000 or prior you don't have that luxury.
Fortunately, Debra Dalgleish has an elegant solution to the problem
he
http://www.contextures.com/xlautofilter03.html#Protect
HTH
DominicB
--
dominicb
------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread:
http://www.excelforum.com/showthread...hreadid=483186