MrExcel.com - Your One Stop for Excel Tips & Solutions

i know i must be repeating the question - but for some reason i can't find the answer

Posted by Ania on January 22, 2002 1:09 PM

i need the macro to run when i open a specific excel file.
Private Sub Workbook_AutoOpen ()
UserForm1.Show
End Sub

Does not work
what am i doing wrong?

Posted by Juan Pablo G. on January 22, 2002 1:16 PM

Should be Workbook_Open()

Posted by Jim on January 22, 2002 1:17 PM

Put your code in "Thisworkbook" and it will work(NT)

Posted by Ania on January 22, 2002 1:22 PM

Thank you:)