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: 38
Default Appearance of Controls misbehaving

Hi - I'm having a peculiar problem with controls (there are 3 command
buttons) on my Sheet. One of the buttons, called cmdPrint, uses the
following code:

ActiveSheet.PrintOut Copies:=2, Preview:=True

This works exactly as expected. BUT, if I view the Preview, then click
'Close' before printing, there is a problem on the Sheet1. The Print button
looks fine, but the other two buttons appear distorted (about five times
taller than they were, and slightly wider). what's going on here? How can I
prevent this?

By the way, if I save and close the file then reopen it, all is back to
normal.

--
Thanks
Sophie
 
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
FileSearch misbehaving Robin Clay[_4_] Excel Programming 8 October 21st 08 10:09 PM
Misbehaving Tab cynlee Excel Worksheet Functions 1 April 3rd 08 05:21 PM
AutoFilter May be Misbehaving Marsh New Users to Excel 7 November 22nd 06 01:48 PM
Workbook Misbehaving bkworks Excel Discussion (Misc queries) 2 August 8th 06 04:09 PM
excel misbehaving R..VENKATARAMAN Excel Discussion (Misc queries) 2 February 19th 06 02:52 AM


All times are GMT +1. The time now is 07:09 PM.

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"