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

[UR_UDAY_KIRAN]

Hi all,

Can we lock the cell or make it as non editable after writing into cell with write cell activity

Please help me to solve this

Thanks

[Manish540 (Manish Shettigar)]

This link may help you,

Range.AllowEdit property (Excel)

[UR_UDAY_KIRAN]

thanks manish, but tis is only to notify the cell is protected or not
i want to lock the cell by uipath which i write into that cell before using write cell activity

[HareeshMR (Hareesh Madasi)]

Heyy @UR_UDAY_KIRAN

You can do that by writing a piece of code or even recording a macro will do that, But only the cells will be locked only when the sheet is locked.

[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

[Deepika_Khandelwal]

good evening sir u have made one bot to read whatsapp messages . Sir I tried but your bot is not working. So it is a humble request if you can help me out .