ExcelBanter - Protection and Filters

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Protection and Filters (https://www.excelbanter.com/excel-worksheet-functions/37702-protection-filters.html)

Karen Fasano

Protection and Filters

Once I lock (protect) an Excel worksheet, I'm unable to use the auto filters.
I'm using Excel 2000. Please help!
--
Karen F

dominicb

Good afternoon Karen Fasano

Debra Dalgleish has a solution to this problem and discusses it he

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

All times are GMT +1. The time now is 05:55 AM.