VBA Excel Button resizes after clicking on it (Command Button)
button, excel, resize, vba
Solution
I added some code to the end of the `onClick` thus:
CommandButton1.Width = 150
CommandButton1.Height = 33
CommandButton1.Font.Size = 11
Seems to work.
I got the issue a slightly different way. By opening the workbook on my primary laptop display, then moving it to my big monitor. Same root cause I would assume.
Problem
How can I stop a button from resizing? Each time I click on the button, either the size of the button or the font size changes. Note: I cannot lock my sheet as my Macro will write into the sheet. Autosize is turned off. I run Excel 2007 on Windows 7 (64 Bit).