How to create custom worksheet protection

[MetteGaga]

Hi,

I have this macro that protects all my sheets in a workbook, and still allows it to filter..

But, i want it to allow more things.

I want to set up the protection as followed (with password):

Select locked cells
Select unlocked cells
Format cells
Use AutoFilter
Edit objects
Edit Scenarios

Please Login or Register  to view this content.

filter1.png
filter2.png

Anyone who can help ?

Thank you in advance

[sktneer]

If you simply record a macro while protecting a sheet allowing the above said permissions, you will get the following code..

Please Login or Register  to view this content.

Try to include the above code into your code like this and see if this works.....

Please Login or Register  to view this content.

Does this help?

[MetteGaga]

It works perfect, thank you.

[sktneer]

You're welcome. Glad to help.