I have 2 tables on the same worksheet. The last row of each table has a cell that contains a comment and another cell that contains a button that runs a macro. I can insert a new row into each of the tables and adjust the row index and cell references of the rows that are below the newly added row and adjust the cell reference of the comment, but how do I change the row in the vmlDrawing for where both the comment and the button should appear?
The short answer is: Save a copy of the original document, make the change manually in Excel, then compare the two to see what has changed. I did a quick check of a comment and found that one of the values in x:Anchor element changed when I moved the cell containing a comment. I assume something similar would work with the button.