Excel Column Protection

Learn Academy Feedback
,
1

Hello,

Suppose i have data in excel from A1:H100 and i would like to protect column C:D. Is there any way i can do that from the bot?

2

If you want to prevent a certain cell from entering a value.
I recommend using Excel’s cell protection feature.

  1. When entering a value in a protected cell.
    image

  2. Column C is protected.

    image
    image802×737 25.3 KB

  3. Docs
    Lock cells to protect them

3

Hello Everyone i Found the Working Solution

  1. Write the VBA Script needed to Lock/Unlock the Columns, I referred this link
  2. Use Invoke VBA Activity in UiPath, pass the correct Function name(as used in VB script)
  3. Pass parameters if needed
  4. Dont forget to enable this inorder to prevent the exception of –
    "Programmatic access to Visual Basic Project is not trusted "
2 Likes
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.