Getting a compile error when trying to unlock a sheet?

[2022]

Hi, I'm trying to use this code to unprotect a sheet (which is locked with a password - let's call it - ZXYD).

However, I'm getting a compile error at the point the code reaches this line.

Does anyone know why that would happen?

ActiveSheet.Unprotect ZXYD

 

[Fluff]

Try

ActiveSheet.Unprotect "ZXYD"

 

[2022]

Thanks Fluff - that solved that problem!

When I re-ran the code, though, I got a "Compile error" at this point, where I'm trying to lock the content of cells again, before protecting the sheet again.

It said "wrong number of arguments or invalid property assignment"

Do you know why that would happen?

Range("M2:XD10").Activate Selection.Locked = True
ActiveSheet.Protect Contents:=True

 

[Fluff]

Try

Range("M2:XD10").Locked = True

 

[2022]

Ok, I tried that.

However, when I ran the code, it stopped at one of the 'locked' columns.

So I tried to add

Range("M2:XD10").Locked = False

right after the this line

ActiveSheet.Unprotect "ZXYD"

ie

ActiveSheet.Unprotect "ZXYD"
Range("M2:XD10").Locked = False

But then the code stopped at that point ie

Range("M2:XD10").Locked = False

Do you know why that would happen?

 

[Fluff]

What error did it give?

 

[2022]

Run time error ‘1004’:

Unable to set the Locked property of the Range class.

 

[Fluff]

Make sure you do not have any merged cells.

 

[2022]

Ok, I’ll look into that. Thank you.

 

[Fluff]

You're welcome.