Hi All
Is it by design or an error?
When selecting few values in a ListBox and then applying Lock no other values (greyed out) can be selected.
However, the Lock is overridden if the selection is within an action of a button (or any other object that can perform commands).
Is that how it is supposed to perform?
I have multiple tabs and each contain Actions, triggered by "On Activate Sheet" such as select Current Year and select Months-to-date, which override Months selected and locked in another tab. That defeats the purpose of the Lock and sharing selected values between tabs.
See attached sample
Thanks