Activities
latest
false
Productivity Activities
Last updated Jul 9, 2024

Protect Sheet

UiPath.Excel.Activities.Business.ProtectSheetX

Enables protecting a specified sheet in Excel so that no additional changes can be made to it. The activity can be used with Excel files selected for parent Use Excel File activities or with the Project Notebook.

Configuring the Activity

In the Body of the Activity
  • Sheet - Click Plus docs image on the right side of the field, then select the sheet you want to protect.
  • Password - Click Plus on the right side of the field, and then, from the menu, select one of the available options:

    • Data from the Project Notebook, a parent Excel file or Outlook account. For example, select an Excel file, and then select Indicate in Excel to indicate a cell from the file, or select an email in Outlook and then select a field in the email that contains the password.
    • Ask when run - Prompt for the password when the project is executed.
    • Paste from clipboard - Paste a value that you previously copied to the clipboard in the project.
    • Use Saved Value - Select a value that you previously saved for later use in the project.
    • Text - Enter the password using the Text Builder.
    • Open in Advanced Editor - Enter a VB expression.
  • Toggle password mode - Alternatively, you can click the toggle password mode button docs image and type in the password manually. Instead of entering passwords directly, we recommend storing passwords securely and retrieving them with an activity such as Get Username/Password.
Properties Panel

Common

  • DisplayName - The name displayed for the activity in the Designer panel.

Input

  • Password - The password required to protect the sheet.
  • Password (SecureString) - The password required to protect the sheet, as a SecureString type.
  • Sheet - The sheet to be protected.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
  • Configuring the Activity

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.