Hi All
I have create 2 Form Buttons in my worksheet, one to calculate the result and the other to Reset/clear the result. What I want is once the Calculate button clicked, it will be disable and grey out, and will be enable again once the result has been clear by clicking the Reset button. Is there a way Macro can do?
Thanks in advance.
Alex
I have create 2 Form Buttons in my worksheet, one to calculate the result and the other to Reset/clear the result. What I want is once the Calculate button clicked, it will be disable and grey out, and will be enable again once the result has been clear by clicking the Reset button. Is there a way Macro can do?
Thanks in advance.
Alex