D
D. Tyler
I am developing a user form that contains a table that utilizes check boxes.
On occasion the user will need to add row(s) to make additional (separate)
entries. In order to carryover the formatting (check boxes) with the newly
added rows, I wrote a simple macro that adds a fully-formatted row. The
sequence is move the cursor to the outside of the last cell, select
Tools>Unprotect Document, Alt+F8 and select the "add row" macro. The macro
runs fine and inserts the row; however, when I reprotect the document (to
allow the check boxs to function properly), all the selections made in the
previous check boxes gets zapped and the entire form is blank. I have tried
all manner of "save" options to no avail. Is this a bug?
On occasion the user will need to add row(s) to make additional (separate)
entries. In order to carryover the formatting (check boxes) with the newly
added rows, I wrote a simple macro that adds a fully-formatted row. The
sequence is move the cursor to the outside of the last cell, select
Tools>Unprotect Document, Alt+F8 and select the "add row" macro. The macro
runs fine and inserts the row; however, when I reprotect the document (to
allow the check boxs to function properly), all the selections made in the
previous check boxes gets zapped and the entire form is blank. I have tried
all manner of "save" options to no avail. Is this a bug?