Protect an Excel Sheet with "Allow Filtering" Option in UiPath

Help Studio
1

I am trying to protect an Excel sheet using UiPath, but I need to make sure that the “Allow Filtering” option is enabled, so users can still use the filters even when the sheet is protected.

While doing this manually, I can check the “Allow Filtering” option when protecting the sheet, but I am not sure how to achieve the same result through UiPath.

Is there any way to programmatically enable the “Allow Filtering” option during the protection of an Excel sheet in UiPath? Or should I use VBA to accomplish this task?

Thanks in advance for any help!

2

Hi @andreus91

You can make use of protect sheet activity

An Excel automation workflow that uses a specified file, saves changes, creates the file if it doesn't exist, and protects a sheet with a password. (Captioned by AI)
An Excel automation workflow that uses a specified file, saves changes, creates the file if it doesn't exist, and protects a sheet with a password. (Captioned by AI)677×621 20.9 KB

and in the properties check on Filter to enable it

The image shows a dropdown menu titled "Options" with various permissions such as deletion, editing, formatting, and inserting, with "Filter" being the selected permission. (Captioned by AI)
The image shows a dropdown menu titled "Options" with various permissions such as deletion, editing, formatting, and inserting, with "Filter" being the selected permission. (Captioned by AI)392×368 5.28 KB

Do mark it as a solution if it helps :innocent:

1 Like