Transforming Button Conditionally
There is an Excel file that teaches how to perform the Transforming Button Conditionally operation.
Excel Spreadsheet for Transforming Button Conditionally
This workbook demonstrates transforming button conditionally using VBA macros on a 1-row data layout.
Hope it is useful.