Help with code to lock cell range during Macro.

[galvinpaddy]

Evening Hapy Campers,

So far i have a code that Jaslake has given some cracking input into (exceptionally appreciated mate)
I now have another question.
Now i have modifed parts of the original code to add some subtle changes, i wont post it all as its massive, my request relates to the section

Please Login or Register  to view this content.

This one works fine, as it unlocks the cell range of J23:35.
I need to then re-lock the range (which is a seperate code) which i thought i could do with the following

Please Login or Register  to view this content.

but when i run this i get the following Run-Time error '1004: Unable to set the locked property of the range class, when i click debug it highligts the following

Please Login or Register  to view this content.

Can anyone pointout where i am failing? if you need to see both codes in there entirety then i will post, but they are very long!!!

galvinpaddy

[jaslake]

Hi galvinpaddy
If it's Protected, you'll need to Unprotect the worksheet first...and you don't need to select

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

[galvinpaddy]

As usual fella, fantastic. thanks so much for the input into this sheet!
Greatly appreciated.