Message when workbook is opened

[Ian]

I need to display a message when a workbook is opened.
I've never done any coding in Excel so can someone give me
some pointers. Thanks!

 

[Mister T]

Private Sub Workbook_Open()
MsgBox "Hi!"
End Sub

 

[Ian]

Thanks. The only problem is that I get the "....contains
macros" message also. Is there a way to disable that?