Macro buttons need to be exorcised

[skysurfer]

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

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

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

Lawrenc

 

[Guest]

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.

 

[Guest]

Using xl2002?

Possibly see these:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002


http://groups.google.co.uk/groups?lr=&[email protected]

 

[skysurfer]

Kevin,

These things always happen in crises mode and I really appreciate your
quick reply. Thanks!

Anyway, I did what you said. In the properties tab of the Format
Control window, there are 3 option buttons. The one stating "Don't
move or size with cells" is selected...and I still get the same
result.

In fact, I created a new spreadsheet and placed a giant command button
on it. Selected the "Don't move..." property in Format Control, saved
the workbook, then printed the page, and the button still flies across
the screen.

Why is this happening to me???

Lawrence

BTW, the version of Excel I'm using is 2002 wth service pack 2.

 

[skysurfer]

Tom,

That's it!!! A bug in 2002. And the link to the work-around works.
Thank you!

Lawrence