Hey there. I have a Workbook with several Sheets. One Sheet (Data Entry Form) has a button on it that runs a macro to save the data entered to a separate sheet (Real Data).
I would like for that button to be disabled at all times unless the data the user entered meets certain criteria. I have a cell (ValidData) on a third sheet (Calculations) that determines that. If ValidData = 0 the button should be disabled and if ValidData= 1 the button should be enabled. This should update anytime the workbook is changed so that it is always correct. And the macro won't run if the data the user entered is wrong.
I am very new at VBA so go easy on me !! LOL
I would like for that button to be disabled at all times unless the data the user entered meets certain criteria. I have a cell (ValidData) on a third sheet (Calculations) that determines that. If ValidData = 0 the button should be disabled and if ValidData= 1 the button should be enabled. This should update anytime the workbook is changed so that it is always correct. And the macro won't run if the data the user entered is wrong.
I am very new at VBA so go easy on me !! LOL