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 Printing same page twice with a subtle change


Hmmm, well, something's not right here. My code is hanging up.
Help???


Sheets("OWTF P.1").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Sheets("OWTF P.1").Select
ActiveSheet.Shapes.AddTextEffect(msoTextEffect2, "For
Return Shipment Only", _
"Arial Black", 36#, msoFalse, msoTrue, 207.75,
363.75).Select
Selection.ShapeRange.IncrementLeft -136.5
Selection.ShapeRange.IncrementTop 34.5
Selection.ShapeRange.ScaleHeight 1.95, msoFalse,
msoScaleFromTopLeft
Range("H35:H38").Select
Range("H38").Activate
ActiveSheet.Shapes("WordArt 43").Select
Selection.ShapeRange.IncrementTop -24.75
Selection.ShapeRange.Fill.Visible = msoTrue
Selection.ShapeRange.Fill.Solid
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(0, 0, 0)
Selection.ShapeRange.Transparency = 0.5
Selection.ShapeRange.Line.Weight = 0.75
Selection.ShapeRange.Line.DashStyle = msoLineSolid
Selection.ShapeRange.Line.Style = msoLineSolid
Selection.ShapeRange.Line.Transparency = 0#
Selection.ShapeRange.Line.Visible = msoTrue
Selection.ShapeRange.Line.ForeColor.SchemeColor = 22
Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255,
255)
ActiveWindow.SelectedSheets.PrintOut Copies:=1


--
remiller131
------------------------------------------------------------------------
remiller131's Profile: http://www.excelforum.com/member.php...o&userid=14888
View this thread: http://www.excelforum.com/showthread...hreadid=265182

 
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
Excel 2002: How to change default page size for printing? Mr. Low Excel Discussion (Misc queries) 3 April 22nd 09 07:01 PM
Excel Printing --Borders are not printing on the same page as data Stup88 Excel Discussion (Misc queries) 1 August 7th 07 09:34 AM
Printing same page twice with a subtle change remiller131[_2_] Excel Programming 0 September 30th 04 09:28 PM
Printing same page twice with a subtle change remiller131 Excel Programming 1 September 30th 04 08:27 PM
Printing second page if data overruns, otherwise print first page playdohstu Excel Programming 1 February 12th 04 02:08 PM


All times are GMT +1. The time now is 04:18 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"