Private Sub Workbook_Open()
UserForm1.Show
End Sub
this goes into a workbook module

click on the xl icon beside the file menu
choose view codes
in the dropdown menu that reads general select workbook
enter the above code that shows the userform
if your userform is not called UserForm1
then enter the name of the userform you want to show at startup


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=538715