Purpose: hide wait dialog programmatically with VBA
You can hide the « Loading worbook, please wait… » dialog box with a VBA call. By default, it is hidden after a given amount of time.
Insert the following code to hide the dialog box:
Set XLSPadlock = Application.COMAddIns("GXLS.GXLSPLock").Object
XLSPadlock.SetOption Option:="3", Value:=""