Application.ShowStartupDialog Property

  • Article
Excel Developer Reference

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

Syntax

expression.ShowStartupDialog

expression   A variable that represents an Application object.

Example

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

Visual Basic for Applications 
  Sub CheckStartupDialog()

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



End Sub

See Also