How to lock the particular excel cell after writing into the cell

[UR_UDAY_KIRAN]

Thank you Hareesh…its working with the code but one can delete sheet and insert and can do some action …please suggest how to avoid that

Please refer this link

How to protect specific sheet in excel

Hi all, I protected excel sheet with locking the cells by using invoke vba this is the code i used Sub Locking() ’ ’ Locking Macro ’ ’ Sheets(“Sheet1”).Select ActiveSheet.Protect(“123”) End Sub and its working fine and no one can edit cells in sheet but anyone can delete or insert sheet and can do some action which given below in picture [image] Please suggest me what all syntax to add to disable that permission Thanks