Thanks Mike. That works.

"Mike H" wrote:

Hi,

You could try checking the 'Use Autofilter' option when you protect the sheet.

Mike

"Ayo" wrote:

I am try to figure out a way to use Auto-filter when some of the cells in a
worksheets are protected. I don't want users to be able to change the data in
the sheet but they need to be able to use Auto-filter in order to do some of
their work. The problem is, anytime we protect the sheet, they can't use
Auto-filter.
Is there a work around for this?

Thank you.