TLDR: Button objects, despite having the "move and size with cells" option selected, won't sort with cells in Excel 2010.
Details:
I made an awesome personnel tracker, complete with little "remove" buttons next to each employee that will archive the employee's data when clicked.
After removal, a ghastly blank spot is left. Deleting the entire row breaks other parts of the workbook, so I must sort to get rid of it.
I use the name of a button to tie it to the name of an employee, so an employee's button needs to stay in that employee's row.
Sorting does not move the buttons, even though "move and size with cells" is selected, and the column that the buttons exist in is included in the sort. Resizing a column or row properly resizes the button.
As a workaround I could use a button's location to tie it to the name of an employee, which wouldn't be so bad, but then each archival action would require all of the buttons below the one clicked to be moved up one row. Scripting that sounds painful, especially when the buttons are supposed to move with their cells.
My brain is fried from spending all day coding, so I'm going to move on to something else and let you guys toy with this one. I'm clearly missing something obvious.
Details:
I made an awesome personnel tracker, complete with little "remove" buttons next to each employee that will archive the employee's data when clicked.
After removal, a ghastly blank spot is left. Deleting the entire row breaks other parts of the workbook, so I must sort to get rid of it.
I use the name of a button to tie it to the name of an employee, so an employee's button needs to stay in that employee's row.
Sorting does not move the buttons, even though "move and size with cells" is selected, and the column that the buttons exist in is included in the sort. Resizing a column or row properly resizes the button.
As a workaround I could use a button's location to tie it to the name of an employee, which wouldn't be so bad, but then each archival action would require all of the buttons below the one clicked to be moved up one row. Scripting that sounds painful, especially when the buttons are supposed to move with their cells.
My brain is fried from spending all day coding, so I'm going to move on to something else and let you guys toy with this one. I'm clearly missing something obvious.
