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.

 


Copyright © 2022 G.D.G. Software