Application.ShowStartupDialog Property (Excel)
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.
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