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

Please reply with any suggestions

gunma

 

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


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


http://tinyurl.com/co6ae

 

[gunman]

Norman,

You're a lifesaver buddy. Thanks

Gunman