Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How I disable a command button until cell has value?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy cell by command button | Excel Worksheet Functions | |||
how to disable/enable command button(ActiveX) using macro | Excel Discussion (Misc queries) | |||
Command button depending on Cell Value | Excel Discussion (Misc queries) | |||
enable/disable button based on cell value | Excel Discussion (Misc queries) | |||
How do i clear a cell using a command button? | Excel Discussion (Misc queries) |