Macro button tiled after print / print preview

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eddie Chan - 30 Dec 2004 00:22 GMT

Dear all,

I have an excel spreadsheet that contains some macro buttons for
doing stat and making charts. This spreadsheet was built in around
year 2000. and it all works fine under Office 98. When it is opened in
Office XP SP3, the same, it works BUT after finishing print / print
preview, (it is okay for the printed pages or print preview page), all
the macro buttons are re-arranged their positions and move to their
left. And if they are on the same row, they will tiled together one by
one. I cannot figure out why. Would somebody help?

Best Regards,
Eddie

Reply to this Message

Gord Dibben - 30 Dec 2004 00:52 GMT

Eddie

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

But Jim Rech recently posted this:

This article is now obsolete. Since the 10/12/2004 security patch
there is no need to get a hotfix (although this article does not directly
mention this fix, it's in there).

http://support.microsoft.com/default.aspx?scid=kb;en-us;832332

But Myrna Larson posted that the patch it didn't work for her in all her
workbooks.

You may have to go with the fix in the first article above.

Gord Dibben Excel MVP

>Dear all,
>
[quoted text clipped - 9 lines]
>Best Regards,
>Eddie

Reply to this Message