VBA Excel - Sheet protection -> retrieve the settings of each sheet of a workbook

[Gagass67]

Hello,

I already partially describe my issue in the subject.
I would like to protect all the worksheets of a workbook with their own protection settings (eg. Allow autofilter, Allow formatting columns, etc...).

see attached Excel Workbook.

Thank you in advance

Regards,
Jean

 

[Marc L]

Hello,​

​

where do you store at least each worksheet protection settings ?​

​