if your 'splash screen' is a user form then try calling your
macro in the on active event of your form. just dont forget to call
doevents once in a while in your macro to update your splash scree.
I think this will do the trick just like the progress bar!
have you tried putting
In several parts of your code?
This will update your userform.
for i=1 to 100000
for j=1 to 10000
for k=1 to 100
With out the doevents your exel will look like hanging up.
but wiht that line, it will be updated.