Hi, I have following code in Thisworkbook to load the form but for
some reason its not loading the form. Can someone pl. tell me what
needs to be corrected.


Private Sub Startup()
Load Frm1
Frm1.Show
End Sub

Private Sub Document_New()
Startup
End Sub

Private Sub Document_Open()
Startup
End Sub

Thanks!
-Payal

Payal,

Are you trying to trap when the user opens or creates a new workbook? If so,
this message by Peter Beach may help:
http://tinyurl.com/2f62a

HTH
Anders Silven

"Payal" skrev i meddelandet
om...
Hi, I have following code in Thisworkbook to load the form but for
some reason its not loading the form. Can someone pl. tell me what
needs to be corrected.


Private Sub Startup()
Load Frm1
Frm1.Show
End Sub

Private Sub Document_New()
Startup
End Sub

Private Sub Document_Open()
Startup
End Sub

Thanks!
-Payal