Hello,

I have searched but did not find an answer which worked for me.

I have buttons to sort a certain column from A to Z and another one to sort from Z to A, which work fine. But I would like these buttons to be disabled if the worksheet is protected, or hide them (which would be even better).

I have tried to: right click the Button --> Format control --> Protection and set it to lock. But this has not worked.

Any way this is possible to do?

Thank you in advance.