Disable/Enable Button

[alexchen]

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

 

[sriram170]

Anyway the user can not do anything if the form is calculation or working behind and if u want to do some gimmicks while the code is running just design another form with attractive colors or place a light grey dull color pic in another form, just put "another form name"(wihout quotes) .show before the code and before the end sub put unload me

 

[Sektor]

You can try

ActiveSheet.Buttons("btnReset").Enabled = False 'Use button name
' or
ActiveSheet.Buttons(1).Enabled = False 'Use index