Urgent help required: lock the data in a cell after entering the value.

**vikrantrai0102** · 02-02-2014, 06:09 AM

Hi,

I am new to vba, need help. details of my requirement is given as:

0: i have a sheet 1 protected and few edit range (Col A,B,C,D,E and F).

1: I have a validation on multiple adjacent columns (like Col A, Col C, Col E).
2: I need a code where if i select value in col a (cell A2) cell B2 should get current date and Time and both the cells (A2 and B2) should be locked. when i select data in cell C2 , D2 should get current date and time(Cell C2 and D2 should be protected).
3: User can enter data in A3 and B3 will get current date and Time (now A3 and B3) should be locked.
4: I need a function where user can call it and unlock the locked cells and edit the data and re-lock the cells again.

apart from the Col A,B,C,D,E and F, other columns and cells remain locked.

Thanks and Regards,
Viki

**jmac1947** · 02-02-2014, 06:15 AM

firstly, please mark the previous thread as solved, it is considered "bad form" to post the same question multiple times, particularly in a ver4y short number of minutes.

Secondly, almost all volunteers on this forum work much better with a sample workbook that includes data and expected results and evidence of what you have tried already to resolve your issue.

Have you recorded the actions manually and examined what was captured for just one example of "your efforts to date"

Sorry to sound grumpy but this is not a free solution providing place, we are here to help you improve your knowledge

**vikrantrai0102** · 02-02-2014, 06:30 AM

Hi Jmac1947,

Thanks for your quick reply.

I have marked the first post as "Solved". As I have mentioned that, I am new to VBA and Coding, so, I have the idea of my work but not the code.

I have attached the workbook for your reference, if you you could please help me solve the issue, it will be a grt help for me.

Thanks and Regards,
Viki