LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Page breaks shift after preview/setting print pref Lara H. New Users to Excel 4 February 14th 08 07:50 PM
have toggle buttons but everytime print preview buttons move TinSandhu Excel Discussion (Misc queries) 1 October 11th 06 02:57 PM
Buttons moving when print preview is done jrude Excel Programming 1 July 26th 05 10:45 PM
Help - Controls Shift after print preview? Koye Li[_2_] Excel Programming 8 March 4th 05 12:45 PM
Macro buttons tiled after print / print preview Eddie Chan Excel Programming 2 January 1st 05 02:50 PM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"