Hi,

I have a workbook that is linked via ODBC to my SQL server.

I would like to have a Splash Screen with a loading bar to appear on screen whilst a Data Refresh occurs. I would like the splash screen to then close after the data has fully refreshed.

The loading bar is not so much of an issue but i need the splash screen on screen and all functions of excel (keyboard, mouse, close etc) to be locked whilst the data refreshes, and only upon completion of the data refresh should the splash screen close and excel functions be restored.

My excel is 2013.