i have 5 sheets,in one sheet i have 2 buttons.
button 1 - COMPARE
button 2 - CREATE
1)when the spreadsheet is opened,i want the CREATE button to be deactivated/disabled and only COMPARE button should be active.
2)once the COMPARE button is clicked,i want to activate/enable the CREATE button and deactivate/disable the COMPARE button.
how to acquire this?
thank in advance.
button 1 - COMPARE
button 2 - CREATE
1)when the spreadsheet is opened,i want the CREATE button to be deactivated/disabled and only COMPARE button should be active.
2)once the COMPARE button is clicked,i want to activate/enable the CREATE button and deactivate/disable the COMPARE button.
how to acquire this?
thank in advance.