Export (0) Print
Expand All
Expand Minimize

Application.ShowStartupDialog Property (Excel)

Published: July 16, 2012

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

expression .ShowStartupDialog

expression A variable that represents an Application object.

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

Community Additions

ADD
Show:
© 2014 Microsoft