Run VBA code before huge calculations

Hi,

I've created a dashboard which consists of a front end, a calculations sheet and multiple data sheets (with several thousand lines of data - and still growing).

The front end of the dashboard is dynamic with around 20 charts.

Each time I drill down the data by department, the calculations sheet has to recalculate (my calculations look at each month week by week) so I put in some VBA code when the button is clicked to put a semi transparent box over the entire screen saying "Loading... Please Wait" - Due to the calculation process taking around 4 seconds - Just so the end user doesnt think it has crashed.

At the moment the calculations seem to take priority, then the semi transparent rectangle appears and then disappears after the charts have changed (I achieved this by activating the shape upon button click, then adding an application.wait command before turning the visibility of the rectangle to false.

Now my question would be, is there any way to show this semi transparent shape BEFORE the calculations start?

Maybe this is too simplistic, but have you tried

Please Login or Register  to view this content.

before the transparent shape, and

Please Login or Register  to view this content.

afterwards?