VBA buttons shift around when using Print/Print Preview

[gunman]

Hey everyone,

I have a bizarre phenomenon happening when I try to print in Excel - it wants to shift all of my buttons I have created for my program to the other side of the screen. To give you some background, I have created a program that uses predefined equations and coding that I have created with macros in visual basic to calculate a result from various inputs. The user inputs their numbers into specific and defined cells and then pushes a calculator button which spits out results into other cells. However, the problem occurs when I try to print a copy of this form with its numbers. Everything prints fine, but when the printing is done, the buttons are then moved to different spots within the Excel interface. I setup some code for them to return to their original position after moving, but this requires the user to again click the buttons. Is there any way to keep this from happening in the first place??

Please reply with any suggestions

gunman

[Norman Jones]

Hi Gunman,

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



"gunman" <[email protected]> wrote in
message news:[email protected]...
>
> Hey everyone,
>
> I have a bizarre phenomenon happening when I try to print in Excel - it
> wants to shift all of my buttons I have created for my program to the
> other side of the screen. To give you some background, I have created a
> program that uses predefined equations and coding that I have created
> with macros in visual basic to calculate a result from various inputs.
> The user inputs their numbers into specific and defined cells and then
> pushes a calculator button which spits out results into other cells.
> However, the problem occurs when I try to print a copy of this form
> with its numbers. Everything prints fine, but when the printing is
> done, the buttons are then moved to different spots within the Excel
> interface. I setup some code for them to return to their original
> position after moving, but this requires the user to again click the
> buttons. Is there any way to keep this from happening in the first
> place??
>
> Please reply with any suggestions
>
> gunman
>
>
> --
> gunman
> ------------------------------------------------------------------------
> gunman's Profile:
> http://www.excelforum.com/member.php...o&userid=23994
> View this thread: http://www.excelforum.com/showthread...hreadid=397224
>

[gunman]

Norman,

You're a lifesaver buddy. Thanks

Gunman