Workbook Open code
 

Use this code in the Microsoft Excel Object called "ThisWorkbook"

Private Sub Workbook_Open()

MsgBox ("Hello")

End Sub




"Neal" wrote in message
...
Dear experts,

I am using Excel 97. When the user opens the workbook, I
would like to have a message box appear and also clear out
some cells from a previous user. I already have the code
for the macro, but how do I have this happen when the
workbook is opened? Thanks in advance.

Neal