Disable or hide a recorded macro button when clicked if the worksheet is protected

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.

Originally Posted by mikerickson

The difficulty with hiding is that one would have to un-hide it when the user unprotects the sheet. Excel doesn't fire an event when a sheet is protected.

The easiest way would be to put something like this in your sorting routine

Please Login or Register  to view this content.

Thank you a lot mikerickson, this works great .