[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Re: Oval-print location

Jim Cone

12/14/2006 12:15:00 AM

You can't specify a print size but you can specify which cells to print.
The PrintArea property of the worksheet handles it.
In the following code change the range to the appropriate cells and assign
the Sub to the Oval or other object...

Sub OnlyPrintThis()
With ActiveSheet.PageSetup
.PrintArea = vbNullString
.PrintArea = Range("C5:G10").Address
ActiveSheet.PrintOut
.PrintArea = vbNullString
End With
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primiti...



"J Whelan" <JWhelan@discussions.microsoft.com>
wrote in message
Have a form w/several "bubbles" to fill in. Way to have an oval, radio
button, or similar, print to a specific location (ie 4.5 inches across, 2.75
inches down)