Hi guys,

I wondered whether a user of a protected sheet can filter the rows while
still having the sheet protected .... Any suggestions ?

Thanks in advance,
Brian

Good afternoon Brian Ferris

XL2002 onwards has this feature in the Protection dialog box. If you
are using XL2000 or prior, then a trip here might help;

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=486244

From the Tools menu under protection option Enable "Use Auto filter"

I Use Excel 2003

"Brian Ferris" wrote:

Hi guys,

I wondered whether a user of a protected sheet can filter the rows while
still having the sheet protected .... Any suggestions ?

Thanks in advance,
Brian