Privasate Sub to unprotect sheet when selected

[Howardc1001]

I have a sheet called "Adjustments"


I have tried to write code so that when a user creates a range name in the bar to the left of the formula bar or when sheet is selected, the sheet will be unprotected. There is no password used

Kindly check and amend my code

Please Login or Register  to view this content.

End Sub [/code]

[sintek]

Please Login or Register  to view this content.

[Howardc1001]

Thanks Sintek

[sintek]

All good...Tx for rep +