Lock edited cells with Macro Button

[tlc53]

Hi there,

I have found instruction on how to lock cells immediately after data has been entered however, I'd like to lock the cells with a push of a button/macro. Is this possible?

Data is currently entered in B12:K105. I would like it so when they hit the "Transfer Journal" button, any cells they have added data to in B12:K105 then becomes locked however, blank cells are editable/can still have data entered later.

Thanks for you time!

 

[Joe4]

You are welcome.

Yes, merged cells are evil and should be avoided whenever possible!
If just merging across single rows, use the Center Across Selection formatting option instead. It will give you the same visual effects without all the issues that merged cells causes for VBA.

 

[tlc53]

That's a very helpful tip! Thanks!
I'll avoid evil merged cells in future