How do I automatically add checkbox or toggle button to Excel 2007 row when adding new row?
Posted on 2011-04-21
I have an Excel 2007 workbook with a Status column. I would like to automatically add a checkbox or toggle button under that column for each row as a new row is added. If the box is checked, I would like its caption to be "Enabled" and if unchecked "Disabled." As an alternative, could have a toggle button automatically added when data is added to a new row that can be toggled between "Enabled" and "Disabled."