Sheet protection does not work as expected when clicking macro button

[Excelquestion35]

Hello,

For a project I require to protect some of the cells in my document, however it is not working as the way it should be.
I protect the sheet by selecting the cells that I want to lock and then protect the sheet in the following way.

My sheet has some macro buttons that require code to unlock the sheet before it runs the code and later protects the sheet with a password.
That code I put inside all macro buttons that I have.

Yet, as soon as I use one of the macro buttons I am not able to use the filter buttons to filter on the columns for instance. (On those columns I did not specifically put a protection and even allowed to use autofilter).
Adjusting any cell values is possible.

My only goal is to prevent people from adjusting certain cells, but other than that the document should be able to be used freely.
What am I doing wrong in order to get the result I want?

 

[Candyman8019]

In your macros when you protect the sheet, you'll need to specify the applicable allowable items. For example:

ActiveSheet.protect Password:="password here",AllowFiltering:=True

 

[Excelquestion35]

I feel stupid, so simple and does the job, thank you!

 

[Candyman8019]

Happy to help.