Open the Controls toolbar and click on the DESIGN button. Right click on one
of your button and select FORMAT CONTROL. Click the PROPERTIES tab and set
the DON'T MOVE OR SIZE WITH CELLS to True. You can also indicate whether or
not you want to print the buttons on this tab as well.
--
Kevin Backmann


"skysurfer" wrote:


About ten years ago, I created a report (a one spreasheet workbook) with
4 command buttons that ran simple macros. Everything worked perfectly.

But today, when I print the spreadsheet, those 4 buttons move all by
themselves to random locations on the spreadsheet.

What little trigger am I missing that keeps the buttons in place when
printing?

Lawrence


--
skysurfer
------------------------------------------------------------------------
skysurfer's Profile: http://www.excelforum.com/member.php...o&userid=34756
View this thread: http://www.excelforum.com/showthread...hreadid=545184