Forum Discussion

Simon Molbech's avatar
Simon Molbech
Copper Contributor
Apr 24, 2018

fix positions height and width

Need help to make a Marco code to make sure that my button are at the same position at all time

It happens that they change size and position - In Format control I've have told that it's not allowed.

 

 

Private Sub CommandButton3_Click()
Import_Risk
End Sub

________________________________________________________________

Private Sub CommandButton4_Click()
IndsætStaffcosting
End Sub

_________________________________________________________________

Private Sub CommandButton5_Click()
IndsætLocal
End Sub

__________________________________________________________________

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Simon,

     

    Please put the button in the position you want, then right-click the button and go to Format Control >> Properties >> Don't move or size with cells

    After that, go to the https://support.office.com/en-us/article/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45 >> Controls and turn off the design mode.

     

    Hope that helps