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
|