title: Buttons resizing in excel-vba on paste
body: <p>I have a macro that performs a number of functions and works properly, but the buttons resize in one of two situations.  The buttons reize when the macro uses an autofilter, which deletes roughly 500 rows of data (the buttons get much larger), and they also resize when I first paste in the data before I run the program (once again get larger). I have tried going into properties and selecting "Don't move or size with the cells" in object positioning.  I have also tried locking the aspect ratio of the buttons. But neither have kept the button from resizing. Any ideas of what else I could try?</p>