Macro to lock certain ranges of cells with formulas

[okela]

Hi,

I'm having trouble with a macro which aims at locking cells which have a formula.
In the attached workbook, I would like to lock the range of cells between J4:J19 because it has a formula.

I found to following code:

Please Login or Register  to view this content.

But I cannot manage to tweak it so it only applies to a certain range of cells. I don't want to lock all the formulas but only a part of them.
I cannot go with the Review tab because the worksheet is going to be duplicated several times and I had issues when I did that.

Could you please help me?

Many thanks!

Okela

[maras_mak]

Will there be good results?

Please Login or Register  to view this content.

[okela]

Hi maras,

Thanks! It's working.

Okela