Thanks, I did do this in the macro before protecting it....

"Gord Dibben" wrote:

Also Autofilter must be enabled before protecting the sheet.


Gord Dibben MS Excel MVP

On Sat, 13 Jun 2009 03:57:01 -0700, Allllen
wrote:

Before protecting the sheet, ensure none of the cells in the range you want
to filter are locked. Then it should work.