Protection and Filters

Karen Fasano · Jul 29, 2005

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

dominicb · Jul 29, 2005

Good afternoon Karen Fasano

Debra Dalgleish has a solution to this problem and discusses it here:

http://www.contextures.com/xlautofilter03.html#Protect

HTH

DominicB