protecting all worksheets of the workbook and open access to filter

[Birnen]

good day. who the hell can give a help for this macro.

what I want is to protect the leaves but leaving open access to filter a column only.

grateful

Please Login or Register  to view this content.

[DonkeyOte]

see: http://www.contextures.com/xlautofilter03.html#Protect

[Birnen]

see: http://www.contextures.com/xlautofilter03.html#Protect

I appreciate the help. but it is hard for me to compile the macro ...

[DonkeyOte]

Macro Recorder gives clues etc...

Please Login or Register  to view this content.