ShowStartupDialog Property [Excel 2003 VBA Language Reference]

  • Article

Returns True (default) when the New Workbook task pane appears for a Microsoft Excel application. Read/write Boolean.

expression.ShowStartupDialog

expression Required. An expression that returns one of the objects in the Applies To list.

Example

In this example, Microsoft Excel determines if the New Workbook task pane appears and notifies the user.

Sub CheckStartupDialog()

    ' Determine if the New Workbook task pane is enabled.
    If Application.ShowStartupDialog = False Then
        MsgBox "ShowStartupDialog is set to False."
    Else
        MsgBox "ShowStartupDialog is set to True."
    End If

End Sub

Applies to | Application Object