to run a macro upon opening a workbook you need to create a macro in th
'ThisWorkbook' object (see top left of VB Editor screen and doubl
click 'ThisWorkbook').

e.g. to show a userform upon opening I have used the following:

Private Sub Workbook_Open()
Quote_Details.Show
End Sub

Hope that help

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