I open my spreadsheet and the buttons become un-aligned

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,147
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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?
 

Attachments

  • out1.png
    out1.png
    7.7 KB · Views: 5
  • out2.png
    out2.png
    7.1 KB · Views: 5

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

eduzs

Well-known Member
Joined
Jul 6, 2014
Messages
693
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
Try set don't move or size with cells under Size and Properties.
Backup before doing any modification.
 
Last edited:

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,147
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Where do I access that from?
 

eduzs

Well-known Member
Joined
Jul 6, 2014
Messages
693
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
Right click button, under Format Control, Properties
 

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,147
Office Version
  1. 365
  2. 2016
Platform
  1. Windows

ADVERTISEMENT

Thanks
 
Last edited:

eduzs

Well-known Member
Joined
Jul 6, 2014
Messages
693
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows

ADVERTISEMENT

You're welcome.
 

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,147
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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

Well-known Member
Joined
Oct 27, 2005
Messages
20,029
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
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

Well-known Member
Joined
Aug 14, 2018
Messages
2,147
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Would any of this code make a difference.

VBA Code:
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
 

Watch MrExcel Video

Forum statistics

Threads
1,127,099
Messages
5,622,697
Members
415,921
Latest member
ExcelGeek5038

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top