Application.UserControl property (Excel)
True if the application is visible or if it was created or started by the user. False if you created or started the application programmatically by using the CreateObject or GetObject functions, and the application is hidden. Read/write Boolean.
expression A variable that represents an Application object.
When the UserControl property is False for an object, that object is released when the last programmatic reference to the object is released. If this property is False, Microsoft Excel quits when the last object in the session is released.
This example displays the status of the UserControl property.
If Application.UserControl Then MsgBox "This workbook was created by the user" Else MsgBox "This workbook was created programmatically" End If
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.