Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Always print to a specific location | Excel Discussion (Misc queries) | |||
How To always print to a specific Location | Excel Discussion (Misc queries) | |||
how can I display the file location (ie:C/mydocuments..)print | Excel Discussion (Misc queries) | |||
Print Failure - Default File Location | Excel Programming | |||
print file path and location in a footer | New Users to Excel |