Hi there,

I'm new to VBA and am stuck in Excel trying to insert an existing chart into a custom dialog box in a DialogSheet. I want to insert it as a picture so users can see it but not do anything with it. One way that sort of worked is just

Workbooks(ref).Worksheets("Charts").ChartObjects(1).Copy
Workbooks(ref).DialogSheets("plot").PasteSpecial

Problem is that then I seem to have no control over the size of the picture, or where it appears in the dialog box.

Any assistance with either a better way of getting the picture into the dialog sheet, or with simply controlling the size and position, is much appreciated

David.