Autofilter With Protection

  • is there a way to use autofilter with a sheet protected even though the cells are not locked? i dont know why this doesnt work?


    thanks

  • Re: Autofilter With Protection


    Hi


    You need to have applied the Autofilter to the sheet before protection was applied to the sheet (ie so the little dropdown arrows must appear on the field headings before you protect the sheet).


    Best regards


    Richard

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!