Home » Forums » Open Source Learning Center » Question and Answer

Autolocking cell after entering number and protecting the cell from editing

Submitted by batya on 1 August, 2014 - 10:40

Hi.
I need help guys with vba.
So I created a table as shown in the attachment file. What I want is to autolock the cells from editing after entering the number between B2:M2, B3:M3 and so on. And password protect each cell under the sum column.
Thanks in advance!

AttachmentSize
autolocking cell after entering number and protecting the cell from editing.xlsx8.82 KB
‹ Macro changing formatting of time VBA code to sort rows that contain offsetting amounts based on account number ›
»