Avoid "flashing" of data - waiting

Hello,

I've got a tendious program to run and i want to avoid the "flashing" of the excel sheets when loading the data. I wonder if there are any VBA codes that can allow a "waiting" signal to appear or move to another page when the data is loading( then return to the original page when the loading is done.)

Any methods would do as long as i can avoid the flashing of the data.

Thanks.