I have a form with a number of command buttons (let’s call them command1, 2, 3) that need to be clicked in order. This will open another form (for some checks to be done) and close the current form. When the checks have been done ‘On Close’ of that form will re-open the form containing the buttons so that the user can move onto the next button and so on until all checks have been done.
In order to prevent the user clicking the buttons out of order, I would like to make all bar ‘command1’ inactive, after clicking command2, command2 becomes active command1 remains active but the back colour changes to indicate it as been clicked. This would continue until all buttons have been clicked but then return to the default of all bar command1 inactive ready for the next time the process is worked through.
My questions are:
What is the VBA code to make the button active/inactive?
What is the VBA code to change the back colour of the button?
What is the best place to put the code e.g. on click of button, on open of new form, of close of form etc. so that at the end of the process it will go back to the default?
Thanks for any help