Filter with protected sheets/buttons

[NoiCe]

Hello,

I have a spreadsheet that contains multiple rows where I want to filter on Column "A". However, I want to do a couple of things.

First, I want to be able to filter even though I have the spreadsheet protected.

Secondly, I don't the auto filter to show. I want to be able to use a button that I create to turn the filter on/off.

Is this possible, and if so how?

Thanks,

- J

[Palmetto]

First, I want to be able to filter even though I have the spreadsheet protected.

First - it would be nice if you completed your profile to indicate which version of Excel you are using.

Allow AutoFilters is a protection setting since version 2000. So, protect the sheet and use the setting.

Macros can run on a protected Sheet with the UserInterFaceOnly argument used with the Protect Method, no need to Unprotect.
Example:

ActiveSheet. Protect  Password:="Secret", DrawingObjects:=True, _ 
Contents:=True, Scenarios:=True, AllowFiltering:=True, _ 
userinterfaceonly:=True

Secondly, I don't the auto filter to show. I want to be able to use a button that I create to turn the filter on/off.

You only need to record two macros and assign them to a checkbox or buttons. Record the first macro turning on and applying the filter criteria and the second macro turning filters off. Try the macro record, post a sample workbook and provide more details if you need more help.