I want to lock perticular cell in excel form being edited.
Can I do it.
If yes then how?

__________________
Sunil

Do you mean a cell in a worksheet or do you mean a textbox in a form?

I mean cell in a worksheet

I'm not sure if you want to do this from code or from Excel but as this is a VBA forum lets assume it is code. In that case select the cell tou want to lock and the following 2 lines of code should do the trick

    Selection.Locked = True
    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

If you want to do it from Excel just lock the cell using the menu Format|Cells... then select the Protection tab and ensure the Locked tickbox is checked. Then use the Tools|Protection|Protect Sheet... menu to protect the sheet and any locked cells will be locked against alteration.

Cheers
nic

Hey Nic,

Thanks again from me; as this was driving me mad yesterday! So I come to the forum and here is the exact answer I was looking for!

Where can you find documentation about excel spreadsheet object properties anyway???

There is nothing like this in the Excel help and on-line links.

Cheers, Joel :D

Hi
 I want to lock perticular cell in excel form Java Programme.Anybody any idea..Let me know...Very urgent to me

Thank U
  Giri

Hi
 I want to lock perticular cell in excel form Java Programme.Anyone have idea..Let me know...Very urgent to me

Thank U
  Giri

Hi Sunil
  This IS Giri From Malaysia.i Need ur Help.I want to lock Exel Sheet or cell.Iam using RAD.Do u have any idea......My id is borugadda007@yahoo.com.Plz Help me