Greeting,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have a macro assign to a button. The button is labeled “Done” and the Macro sub is called “Sub Save_Final()”. The button is placed in sheet1 cell J20.
When there is an error on the worksheet, I would like to disable (or grey out) the Done button. Otherwise, the button is enable. An error checking mechanism has been implemented and working correctly. An error checking is if there is an error cell J30 on the same sheet is not zero (one or greater).
<o> </o>
Would somebody please help me? Thanks.
First time post but been reading the forum for some time.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have a macro assign to a button. The button is labeled “Done” and the Macro sub is called “Sub Save_Final()”. The button is placed in sheet1 cell J20.
When there is an error on the worksheet, I would like to disable (or grey out) the Done button. Otherwise, the button is enable. An error checking mechanism has been implemented and working correctly. An error checking is if there is an error cell J30 on the same sheet is not zero (one or greater).
<o> </o>
Would somebody please help me? Thanks.
First time post but been reading the forum for some time.