Excel Bug Moves Cmd Buttons When Print  
Author Message
digital843





PostPosted: Thu Aug 11 01:29:52 CDT 2005 Top

Excel Programming >> 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

Excel386  
 
 
Norman





PostPosted: Thu Aug 11 01:29:52 CDT 2005 Top

Excel Programming >> 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.aspx?scid=kb;EN-US;838910


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

http://tinyurl.com/co6ae


---
Regards,
Norman





>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
>