Protect Autofiler Column

[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

 

[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

 

[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

 

[Guest]

I have Excel 2000.

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

 

[Ron de Bruin]

Hi Mickey

Then it is possible with code
http://www.contextures.com/xlautofilter03.html#Protect

 

[Guest]

Thank you so much. It works great.

Hi Mickey

Then it is possible with code
http://www.contextures.com/xlautofilter03.html#Protect