Hi Gary,

I assume that you have made yourself a user form to use as a splas
screen.

Assume the form name is "Splash", then in the first line of your macr
that is running place 'Splash.Show' and the last line of the macr
would then be either 'Splash.Hide' or 'Unload Splash'

HTH

Gordon :

--
Message posted from http://www.ExcelForum.com