Hi dreamz

Before you protect the sheet turn on AutoFilter

See also
http://www.contextures.com/xlautofilter03.html#Protect


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


"dreamz" wrote in message
...

for some reason, excel gives me the following error when i try to
execute an autofilter command on a protected worksheet:


run-time error '1004':

you cannot use this command on a protected sheet. etc. etc.

even though i set "allow all users of this worksheet to: use
autofilter" in the options dialog. what's wrong?


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=535565