[RESOLVED] Unprotect sheet VBA Excel

Hi guys,
I want to know how to check is the sheet is protected before unprotecting it.

I cannot find the sheet property for this.

Any idea??
Macro VBA Excel


Thanks

Its the ActiveSheet.Protection property and the ActiveSheet.ProtectionMode object to determine the level/type of protection on a sheet.

ProtectionMode was what I was looking for.

Thanks RobDog888