'VB To Allow Filtering When Protecting Worksheet
I have a Blueprism object which will protect a worksheet but leave a range of cells unprotected. I want to be able to filter this worksheet. The below code will add filters but you cannot select the drop down. Note range and handle are variables being passed in.
GetInstance(handle).Range(range).Locked = False
GetInstance(handle).Range(range).EnableAutoFilter
GetInstance(handle).ActiveSheet.Protect
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|