I have created a spreadsheet that uses an auto filter. It works fine on
my pc and on some others, however some friends say that whilst the auto
filter box is visible if they select it nothing happens (no drop down
list).

The autofilter is in an unprotected cell, the worksheet/workbook is
protected but not a shared wook book. One of the users gains access to
the filters if he upprotects the workbook only.

The problem does not seem to be related to version or operating system
being run.

Could it have something to do with a general setting in excel, or
anyone else come accross a similar problem.

Secondly (maybe related?) from the 'DATA' 'FILTER' menu in the
protected sheets/workbook the autofilter is checked and greyed out but
the advanced filter can still be selected. If one of the users selects
the advanced filter it over rides the previous auto filter, then i need
to unprotect the sheet and re-protect to use the autofilter again. How
(if possible) can I prevent them selecting advanced filter to stop this
problem occuring?

Many thanks if someone can help....
Ron


--
ronwill
------------------------------------------------------------------------
ronwill's Profile: http://www.excelforum.com/member.php...o&userid=30277
View this thread: http://www.excelforum.com/showthread...hreadid=499449