Workbook.DisplayDrawingObjects Property (2007 System)

Gets or sets how shapes are displayed.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

Syntax

'Declaration
Public Property DisplayDrawingObjects As XlDisplayDrawingObjects
'Usage
Dim instance As Workbook 
Dim value As XlDisplayDrawingObjects 

value = instance.DisplayDrawingObjects

instance.DisplayDrawingObjects = value
public XlDisplayDrawingObjects DisplayDrawingObjects { get; set; }
public:
property XlDisplayDrawingObjects DisplayDrawingObjects {
    XlDisplayDrawingObjects get ();
    void set (XlDisplayDrawingObjects value);
}
public function get DisplayDrawingObjects () : XlDisplayDrawingObjects 
public function set DisplayDrawingObjects (value : XlDisplayDrawingObjects)

Property Value

Type: XlDisplayDrawingObjects
One of the following XlDisplayDrawingObjects values: xlDisplayShapes, xlPlaceholders, or xlHide.

Examples

The following code example adds a doughnut shape to worksheet Sheet1 of the current workbook, and then prompts the user to hide drawing objects by using the DisplayDrawingObjects property. If the user hides drawing objects, then the doughnut shape will be invisible; otherwise, the doughnut shape will be visible.

This example is for a document-level customization.

Private Sub AddCustomView()
    Me.CustomViews.Add("Summary", True, True)
    Me.Application.Dialogs( _
        Excel.XlBuiltInDialog.xlDialogCustomViews).Show()
End Sub
private void AddCustomView()
{
    this.CustomViews.Add("Summary", true, true);

    this.Application.Dialogs[Excel.XlBuiltInDialog.xlDialogCustomViews].Show(
        missing, missing, missing, missing, missing, missing, missing, missing,
        missing, missing, missing, missing, missing, missing, missing, missing,
        missing, missing, missing, missing, missing, missing, missing, missing,
        missing, missing, missing, missing, missing, missing);
}

.NET Framework Security

See Also

Reference

Workbook Class

Workbook Members

Microsoft.Office.Tools.Excel Namespace