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?

 

[eduzs]

Try set don't move or size with cells under Size and Properties.
Backup before doing any modification.

 

[dpaton05]

Where do I access that from?

 

[eduzs]

Right click button, under Format Control, Properties

 

[dpaton05]

Thanks

 

[dpaton05]

.

 

[eduzs]

You're welcome.

 

[dpaton05]

Actually, that doesn't work as the table will have rows cells added to it and the buttons need to move accordingly. If I select your option, the rows are added and the buttons are not moved so they remain the same distance from the table.

 

[Michael M]

Have you looke at your Auto_open macro to see if there is anything in that code that is throwing the buttons off ?
Otherwise, you may need to incorporate the button positions into the Auto_open macro to make sure they stay the same.

 

[dpaton05]

Would any of this code make a difference.

Private Sub Workbook_Open()
Quoting.Unprotect Password:=ToUnlock
    ThisWorkbook.Worksheets("Start_here").Activate
        With ThisWorkbook.Worksheets("CSS_quote_sheet")
            .Shapes("cmdGarrettB").Visible = True
        End With
        Start.Unprotect Password:=ToUnlock
            Application.Goto Reference:=Worksheets("Start_here").Range("a1"), Scroll:=True
        Start.Protect Password:=ToUnlock
Quoting.Protect Password:=ToUnlock
End Sub