VBA Password Protection

Hi, I wonder whether someone may be able to help me please.

I'm trying to add some worksheet protection to my script which allows a 'On Opne' script to run then prevents the user from making any change to the spreadsheet

This is very simple script I've put together, but for some reason, the sheet is not being protected at the end of the script.

Please Login or Register  to view this content.

I've also tried:

Please Login or Register  to view this content.

which does protect the sheet, but doesn't the rest of my script to run.

I just wondered whether someone may be able to look at this please and let me know where I've gone wrong.

Many thanks and kind regards

Chris

Not seeing

'Rest of script

it's just guessing
but:
which sheet is activesheet
does it change during the rest of the script
do you open other workbooks in the rest of the script
is there some error handling in the rest of the script
is there exit sub?
etc.

Good to hear that, and thanks for sharing the solution