VBA buttons shift around when using Print/Print Preview
 

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

--
gunma
-----------------------------------------------------------------------
gunman's Profile: http://www.excelforum.com/member.php...fo&userid=2399
View this thread: http://www.excelforum.com/showthread.php?threadid=39722

VBA buttons shift around when using Print/Print Preview
 

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

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

VBA buttons shift around when using Print/Print Preview
 

Norman,

You're a lifesaver buddy. Thanks

Gunman


--
gunman
------------------------------------------------------------------------
gunman's Profile: http://www.excelforum.com/member.php...o&userid=23994
View this thread: http://www.excelforum.com/showthread...hreadid=397224