ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro buttons tiled after print / print preview (https://www.excelbanter.com/excel-programming/319795-macro-buttons-tiled-after-print-print-preview.html)

Eddie Chan

Macro buttons tiled after print / print preview
 
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

Ken Wright

Macro buttons tiled after print / print preview
 
Documented bug with a hotfix available

http://support.microsoft.com/default...b;EN-US;838910

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Eddie Chan" wrote in message
om...
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




KRCowen

Macro buttons tiled after print / print preview
 
Eddie
I had a lot of trouble getting the "hot fix" to fix anything, but the problem
was corrected when I moved to Excel 2003.
Ken


All times are GMT +1. The time now is 12:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com