Disabling Function of a Private Sub

Question

I am doing a form using the userform in excel.

The form has the following capability
a. save to dump the data on one sheet of the excel
b. retrieve the data that was previously saved to make changes using the search button
c. one of the checkboxes has the code for .vbinformation (to ensure that they enter the answer to a text box available beside)
d. one of the checkboxes has the feature to show another user form to enter data needed.

However, I want to disable the function C and D above whenever I retrieve the data from the dumpfile and just have the checkboxes automatically checked without running the C and D feature as it is only applicable whenever the data being entered is new and not the old.

Please help on what should I need to do about this?

Thanks,
Mark

Answer 1

In the code for b., incorporate commands to set the Enabled attribute of the c. and d. checkboxes to False