Microsoft continues to remove functionality and flexibility, while adding a lot of useless wizards and widgets to impress idiots. You format it so that it does not change size or move with Cells.3.
There are a lot of people commenting answers that do not seem to understand the problem. You perform some operation with the workbook (maybe printing, maybe preview, maybe save).
Incorrect settings almost always cause serious problems with Excel buttons, especially Active X controls. Height - 1I believe the issue affects those that have recently upgraded from Excel2003 to later versions.
Placement = 3For those who might be interested, setting that value to '1' is the default move and resize the button, and the value '2' is move but don't resize. When a fixed position is set, no activity whatsoever should affect that position.
If I choose to make the top row blank at a fixed height, and choose to top-center a button on the visible worksheet, no resizing of the window, or scrolling should affect that it is centered and at the top of that worksheet.
Sometimes, on repeated clicks, the font can shrink to unreadable size; other times they expand to cover the whole screen. Check this link: I use check boxes throughout a workbook that has about 40 pages/tabs.
Active X controls can be changed after you print preview, print, or save a workbook. Microsoft has issued a hotfix, but it is seriously tedious to implement. Mostly, yes/no questions throughout a worksheet so I can't "Freeze Panes" rows, columns or otherwise in a specific area as suggested by Aldo.