How To Disable The Macro Button??

[hally]

Good day,

How I want to disable the macro button??

I mean is I have 1 command button ( Sort Numbers DEMAND ). This button is work when the user click at the first time.

After the second time, the button did not work as what I want. It will copy all the data and paste it into a new row.. So how I want to disable it??

Thank you so much for helping me..

[royUK]

There is no code attached to the button. What exactly do you mean?

[hally]

There is no code attached to the button. What exactly do you mean?

What I mean is, When I click the Button which is Sort Numbers DEMAND, it just can function successfully for one time only.. When the user click for the second time, it will copy the data and will paste it into the new row.. So how I want to disable that??

Thank You So Much..

[royUK]

A I said there is no code attached to that button, but if you disable it how woulod you re-enable for later use?