Oval-print location
 

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/primitivesoftware



"J Whelan"
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)