Problem with lock range

[LuisLi90]

Hello, i have a problem with a subrutine.

I did a subrutine to lock a specific range, but there are locked cells where i can write. If i look in format cell, I can see that the cell is blocked.

So, I'm looking something to solve this issue, any solution?

Thanks in advance.

L.

 

[Eric Golf]

Hi,

In order for locked cells to take effect you also need to Protect the Worksheet.

Hope this helps,

Eric

 

[LuisLi90]

Hi,

In order for locked cells to take effect you also need to Protect the Worksheet.

Hope this helps,

Eric

Hi,

I did it, and there are some cell locked, and other unlocked. This cell unlocked, appear in format control like cell locked, but i can write.