Macro buttons need to be exorcised
 

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

--
skysurfe
-----------------------------------------------------------------------
skysurfer's Profile: http://www.excelforum.com/member.php...fo&userid=3475
View this thread: http://www.excelforum.com/showthread.php?threadid=54518

Macro buttons need to be exorcised
 

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

Macro buttons need to be exorcised
 

Using xl2002?

Possibly see these:

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


http://groups.google.co.uk/groups?lr...apeXSP AM.com

--
Regards,
Tom Ogilvy


"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

Macro buttons need to be exorcised
 

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
------------------------------------------------------------------------
skysurfer's Profile: http://www.excelforum.com/member.php...o&userid=34756
View this thread: http://www.excelforum.com/showthread...hreadid=545184

Macro buttons need to be exorcised
 

Tom,

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

Lawrence


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