Locking cells on Excel

[Short]

Hi all

I just wondered if there was a way to use UiPath to lock certain columns in Excel, e.g. lock A through R and leave S unlocked?

Thanks

[Anil_G (Anil Gorthi)]

@Short

You need to go with writing a macro/vba for it and then Invoke it

Cheers

[Short]

Hey

Do you know what the VBA code for it would be please? I’ve tried looking and nothings working

[ClaytonM]

In addition to using vba or vbscript, you can also interact with the menu ribbon features using keystrokes, which I’ve had success in doing it:

TypeInto ralt+“rps”
TypeInto “password”
SendHotkey Alt+m
etc…

EDIT: and use Select Range prior to those interactions

[Anil_G (Anil Gorthi)]

@Short

Sub(Rangevar as String)
      ActiveSheet.Range(Rangevar).Locked = True
End Sub

for your case you can pass range as A:R

Also make sure to protect the workbook first only then lock will work

cheers