Is there any way of disabling a button on a worksheet when the worksheet is
protected, i.e. I do not want people to click the button to refresh the data
if the sheet is protected? (the button is from the Control Toolbox toolbar)

Any ideas?