Protect Autofiler Column


G

Guest

How can I Protect a Worksheet that has a autofilter column. I want users to
be able to use the drop down menu in the autofilter column to narrow the
selections but I don't want users to have the ability to change anything on
the spreadsheet. If I unlock the autofilter column and protect the sheet it
doesn't activate the dropdown.

Thanks,
Mickey
 
Ad

Advertisements

R

Ron de Bruin

Hi Mickey

In 2002 and up this is a option when you protect your sheet.
Tools>Protection...Protect sheet
check "Use AutoFilter"

But first apply the filter before you protect the sheet
 
G

Gord Dibben

Mickey

Which version of Excel?

In 2002 and 2003 you can protect the worksheet with "Use Autofilter" checked on.

You must have the autofilter already enabled before protecting the sheet.


Gord Dibben MS Excel MVP
 
G

Guest

I have Excel 2000.

Ron de Bruin said:
Hi Mickey

In 2002 and up this is a option when you protect your sheet.
Tools>Protection...Protect sheet
check "Use AutoFilter"

But first apply the filter before you protect the sheet
 
Ad

Advertisements

Ad

Advertisements


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

Top