Hi

Does anyone know how to create a splash screen for about
10 seconds. I've tried one using the timer with limited
success, and I'd like not to pause everything while the
screen is being displayed.

As it'll be appearing when I open the workbook, I guess
that the Workbook_Open sub is the best place to start.

Many thanks
Libby

John Walkenbach shows one approach:

http://j-walk.com/ss/excel/tips/tip39.htm
Creating a "Splash Screen" for an Excel Workbook

--
Regards,
Tom Ogilvy


"Libby -xl97" wrote in message
...
Hi

Does anyone know how to create a splash screen for about
10 seconds. I've tried one using the timer with limited
success, and I'd like not to pause everything while the
screen is being displayed.

As it'll be appearing when I open the workbook, I guess
that the Workbook_Open sub is the best place to start.

Many thanks
Libby

Excellent!

Thanks Tom
-----Original Message-----
John Walkenbach shows one approach:

http://j-walk.com/ss/excel/tips/tip39.htm
Creating a "Splash Screen" for an Excel Workbook

--
Regards,
Tom Ogilvy


"Libby -xl97" wrote
in message
...
Hi

Does anyone know how to create a splash screen for about
10 seconds. I've tried one using the timer with limited
success, and I'd like not to pause everything while the
screen is being displayed.

As it'll be appearing when I open the workbook, I guess
that the Workbook_Open sub is the best place to start.

Many thanks
Libby


.