ProtectSelection Property

Microsoft Excel Visual Basic

ProtectSelection Property

       

True if chart elements cannot be selected. Read/write Boolean.

Remarks

When this property is True, shapes cannot be added to the chart, and the Click and DoubleClick events for chart elements don’t occur.

Example

This example prevents chart elements from being selected on embedded chart one on worksheet one.

Worksheets(1).ChartObjects(1).Chart.ProtectSelection = True