You did not post your code but maybe this 1st line will do it.
if sheet1!a1<12345 then exit sub

"Brian" wrote in message
...
I have a workbook with many worksheets(25), on one
worksheet is a command button that when clicked locks all
cells in all worksheets, once all the data required is
entered. What I need is to disable this button until a
cell on the first worksheet has a specific value, can
anyone please help with the necessary code or macro?

The appropriate cell is E41 on sheet1, it has to have the
value "For Contract" to allow the button to be used.

Thank you in advance for any assistance.

Brian