| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel shape xy poisiton in A4 paper
I want to build a cheque print software in excel and i have a problem . I want to draw a shape in A4 paper in the exact location for example 10cm (top) * 9 cm (left) but after printing the shape place is incorrect of A4. my code: topPoint = 13 'cm leftPoint = 18 'cm topPoint = Application.CentimetersToPoints(topPoint) - sht.PageSetup.TopMargin leftPoint = Application.CentimetersToPoints(leftPoint) - sht.PageSetup.LeftMargin sht.Shapes.AddShape msoShapeRectangle, leftPoint, topPoint, 10, 10 Kindly help me. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create shape, name shape, add text to shape | Excel Programming | |||
| Mattter typed on Legal paper want to get it on A4 size paper | Excel Programming | |||
| my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
| Deleting a shape and the cell contents the shape is in. | Excel Programming | |||
| Deleting a shape and the cell contents the shape is in. | Excel Programming | |||
Hybrid Mode
