When I open a workbook I would like a dialog box that has a message that
opens on the screen and the user has to click the ok button to clear the
message and start working. Any help would be appreciated.

Thanks in advance
greg

In the VBA editor right click on workbook and 'view code' change the right
hand box to say open and add the following:

Private Sub Workbook_Open()

MsgBox "Your text here", vbOKOnly, "Title"

End Sub


"Greg" wrote:

When I open a workbook I would like a dialog box that has a message that
opens on the screen and the user has to click the ok button to clear the
message and start working. Any help would be appreciated.

Thanks in advance
greg