Neal,

Open the ThisWorkbook code module, and enter the code

Private Sub Workbook_Open()
' your code here
End Sub

This event procedure will execute when the workbook is opened.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"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