This topic has not yet been rated - Rate this topic

ModuleView Object

Office 2007
Represents existing Module views in the workbook.

Remarks

The module area includes everything, including the plot area of a chart. However, the plot area has its own fill, so filling the plot area does not fill the module area.

Example

The following example turns off the border for the chart area in embedded chart 1 on the worksheet named "Sheet1".

Visual Basic for Applications
Worksheets("Sheet1").ChartObjects(1).Chart. _
    ChartArea.Format.Line.Visible = False



Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ