XLS Padlock Guide
XLS Padlock Guide

Hide wait dialog programmatically with VBA

 

 

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:=""