Help with using Auto-filter in a protected Worksheet.

G

Guest

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.
 
G

Guest

Hi,

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

Mike
 
G

Guest

Hey Mike,
I just tried it with another file and it isn't working on that file. What
could be the problem?
 
G

Gord Dibben

Ayo

Data Filter must be enabled on a range before you protect the sheet with the
"Use Autofilter" checked.

i.e. select a range and Data>Filter>Autofilter to get the arrows.

Now protect the sheet.


Gord Dibben MS Excel MVP
 
G

Guest

Thanks Gord.

Gord Dibben said:
Ayo

Data Filter must be enabled on a range before you protect the sheet with the
"Use Autofilter" checked.

i.e. select a range and Data>Filter>Autofilter to get the arrows.

Now protect the sheet.


Gord Dibben MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I protect a range but allow auto filtering in earlier versi 1
Use auto filter in a protected worksheet 5
Macro to allow auto filter after running password protect 1
Sorting in a protected sheet 1
Allow Auto Filter in Protected Sheet 1
Auto Filter - Protected sheet/workbook 3
How to Activate "Show all" in a Protected Shared Workbook 1
Auto Filter in Row dimension 1

Top