Drawings Method

Applies To

Chart Object, DialogSheet Object, Worksheet Object.

Description

Accessor. Returns an object that represents a single drawing (a Drawing object, Syntax 1) or a collection of drawings (a Drawings object, Syntax 2) on the sheet. Drawings are created by the Freeform, Freehand, and Filled Freeform buttons on the Drawing toolbar.

Syntax 1

object.Drawings(index)

Syntax 2

object.Drawings

object

Required. The Chart, DialogSheet, or Worksheet object.

index

Required for Syntax 1. The name or number of the drawing to return. More than one index can be specified.

Example

This example brings drawing one to the front of Sheet1.

Worksheets("Sheet1").Drawings(1).BringToFront