View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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