I open my spreadsheet and the buttons become un-aligned

[dpaton05]

I have a spreadsheet that has a sheet with a table. Under the table there is a row of 3 buttons. Each time I get to work, I open the spreadsheet and have to line the buttons up again. I have uploaded 2 images, out1 is what the buttons look like, each time I open them on a new day and out2 is what they are meant to look like. I don't know why they keep moving or where I could look for a possible cause. Can someone give me some ideas of where I could look please?

 

[Michael M]

I don't believe so, unless this modifies you shape positions, but I don't know where that shape sits !!

.Shapes("cmdGarrettB").Visible = True

Try commenting that line out and see what happens,

 

[dpaton05]

Thanks for the idea of setting the position of the buttons manually, I will give that a go.

 

[jtakw]

Hi,

Using a copy of your Workbook, try "Grouping" your buttons in Design Mode.

 

[Michael M]

@jtakw
Yep.....why use code when the obvious will do....hopefully...

 

[eduzs]

Try change to move but not size with cells.