hi
you could put a sub in the workbook open event to display the form then use
the application.ontime event to call a sub that closes the form.
look up application.ontime in vb help and see this site for more details. http://www.cpearson.com/excel/ontime.htm