Please help me...I have tried so much searching for days now and am not getting anywhere but am trying to self teach here. Created in Excel 2002 (Thanks to work budget)
I am trying to dynamically create some buttons and place them over certain cells. This is sort of going to plan, however the buttons seem to start fairly well lined up with the cells, but end up a few pixels out further down the sheet. This leads to another problem of when the macro runs to delete its own row the topleft button reference does not reflect the actual row it is supposed to be in.
I have linked my spreadsheet in Google Drive as my work conputer will not let me add the attachment. (Click File and Download):
https://drive.google.com/file/d/1I6V...it?usp=sharing
You'll see that the buttons in the first created rows line up better than the last ones in the AOB section and this changes depending upon how many rows are created above...?
Please can anyone assist? I have tried to nudge down slightly to line up, but when further rows are added above the buttons move again.
Many thanks in advance,
Shane
Bookmarks