ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Bug Moves Cmd Buttons When Print (https://www.excelbanter.com/excel-programming/336978-excel-bug-moves-cmd-buttons-when-print.html)

BlackbeltDomains.com

Excel Bug Moves Cmd Buttons When Print
 
I am having a problem with my customized reports (custom programmed reports
using vba to connect to our SQL Server database). Ever since we updated our
Office XP with the office update website, now when I open my customized
reports and run them, as soon as I print or hit print preview and then come
back to the excel worksheet, all of the command buttons and text boxes are
moved to the left side of the screen... and stacked on top of each other.
What the heck is that all about? If I close and reopen it's fine (until I
print preview or print the report again).

What is causing the cmd buttons and text boxes that I have put on the
worksheet to move out of place?

Hope someone has seen this before.
--
www.blackbeltdomains.com
www.blackbeltdomains.biz


Norman Jones

Excel Bug Moves Cmd Buttons When Print
 
Hi BlackBeltDomains,

See MSKB Article # 838910 (Controls move to the left of the worksheet in
Microsoft Excel 2002) :

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


See also the final contribution (from Bob Phillips) in the following thread:

http://tinyurl.com/co6ae


---
Regards,
Norman



"BlackbeltDomains.com" wrote
in message ...
I am having a problem with my customized reports (custom programmed reports
using vba to connect to our SQL Server database). Ever since we updated
our
Office XP with the office update website, now when I open my customized
reports and run them, as soon as I print or hit print preview and then
come
back to the excel worksheet, all of the command buttons and text boxes are
moved to the left side of the screen... and stacked on top of each other.
What the heck is that all about? If I close and reopen it's fine (until I
print preview or print the report again).

What is causing the cmd buttons and text boxes that I have put on the
worksheet to move out of place?

Hope someone has seen this before.
--
www.blackbeltdomains.com
www.blackbeltdomains.biz





All times are GMT +1. The time now is 02:18 PM.

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