the position of my controls change after clicking on them, despite my attempt to fix position by the code below. Is there anything else I should do? Please help.
Private Sub CalculateMe_Click()
Dim btn As Shape
Set btn = ActiveSheet.Shapes("CalculateMe")
btn.height = 30: btn.width = 75
btn.Top = 151.2: btn.Left = 422.4
' other code here
End Sub
New contributor
Florin Home is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.