Terminate the "Loading workbook message" early

Purpose: terminate the "Loading workbook message" early from VBA

Here is the VBA code to hide that dialog box earlier:

Dim XLSPadlock As Object
Set XLSPadlock = Application.COMAddIns("GXLS.GXLSPLock").Object
XLSPadlock.SetOption Option:="3", Value:="0"
 

 

Invoke this when you want the Loading workbook message to be hidden.