Autolocking cell after entering number and protecting the cell from editing

Hi
Three simple macros will do this for you.

The first one will run when you open the workbook
It selects your sheet and range B2 but those lines are not important.
The important part is that it creates a public variable "Store"

Please Login or Register  to view this content.

The Second Macro does two things.

Firstly it moves the cursor to N1 whenever any cell in column N is selected.
This prevents column N being modified.

Secondly if any cell in your data range is selected, it saves the value in that cell in store.

Please Login or Register  to view this content.

The last macro, stops any cell in the data range being modified.

Please Login or Register  to view this content.

Dear Mehmetcik.
Since I'm no good in programming can you help me with making final version of the excel table. I created the final version of the table and attached to the thread. Logic is same autolock after entering the number cell from B2:Y2 and downwards. And protecting the cells starting from Z2 and downwards. And can you help me with enabling and disabling the protection of the cells from Z2 and downwards.
Thank you very much my friend.

P.S. And one more problem. When I try delete or modify any cell in range B2:Y2 i can't but when I select two and more cells and press delete it give run time error "13" and deletes the content/s of the cell.