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