controling a excel sheet Cell using a visual basic code

[shakthisarav]

Hi Frnz pls help me in doing the below task ............... ..

problem:

Add one combo to the excel spreadsheet. let it be in cell 'd1'.the combo should contain items as lock & unlock.when we click on lock the cells a1:c1 must be disabled. the cell e1 should be able to display the name of person who locked the cell. some authentication must be made on that time.the person who locked the cell can only unlock the cell.


can any one help me ............... ...

[debasisdas]

what you have tried so far.