Splash Screen during OLAP cube refreshing?

[scott]

I have an excel spredsheet with a pivot table linked to an OLAP cube.
I have created a button that makes it easy for users to refresh the
cube and table. However, it takes about 10 - 15 seconds somtimes to
refresh. Is there anyway to create a screan that will display during
the refreshing and leave after the data is refreshed. The screen
(just a VBA form i think) would say "....processing. Please wait."
Or something to that effect. Is this possible and if so can anyone
give me an idea of what the code would look like. If anyone can help
I would be greatly appreciate. Thanks!

-Scott

 

[Tomm \(portrett.no\)]

If you create a form and set ShowModal property to false you should be able
to display that dialog while code is running.