Applying autofilter to protected sheet
 

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

Applying autofilter to protected sheet
 

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

Applying autofilter to protected sheet
 

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