mykal66
11-03-2020, 10:56 PM
Hi
I use a couple of bits of code on various workbooks but when i try to combine I can't get the result I want.
To make workbooks neater i add a greyed out row at the bottom of entered data then add a cmd button into the greyed out cell in Column A and some code that adds a new row above with formatting etc whenever the user needs a new row which works fine on it's own
The second piece of code moves a row of data to another worksheet when a specific status is set in a column and deletes the original row and this works fine on it own too.
It's when i try to combine both in one workbook i get stuck because when the row is moved and deleted the cmd button moves our of the greyed out cell so when the user click the add new row button it add below the greyed out row.
Is there a way to fix the cmd button into the greyed out row no matter where it moves?
Thanks for any pointers and i have attached an example workbook
Mykal2739927399
I use a couple of bits of code on various workbooks but when i try to combine I can't get the result I want.
To make workbooks neater i add a greyed out row at the bottom of entered data then add a cmd button into the greyed out cell in Column A and some code that adds a new row above with formatting etc whenever the user needs a new row which works fine on it's own
The second piece of code moves a row of data to another worksheet when a specific status is set in a column and deletes the original row and this works fine on it own too.
It's when i try to combine both in one workbook i get stuck because when the row is moved and deleted the cmd button moves our of the greyed out cell so when the user click the add new row button it add below the greyed out row.
Is there a way to fix the cmd button into the greyed out row no matter where it moves?
Thanks for any pointers and i have attached an example workbook
Mykal2739927399