Hi Marilyn,

Try posting the following code in the ThisWorkbook module:

'==========
Private Sub Workbook_Open()
Call Form23
End Sub
'<<==========


This is workbook event code and should
be pasted into the workbook's
ThisWorkbook module *not* a standard
module or a sheet module:

Right-click the Excel icon on the worksheet
(or the icon to the left of the File menu if
your workbook is maximised)
Select 'View Code' from the menu and paste
the code.
Alt-F11 to return to Excel.



---
Regards.
Norman


"Marilyn" wrote in message
...
Hello this is my message box
Sub Form23()
Dim Msg As String
Msg = "Complete Attached Form " & vbCrLf
Msg = Msg & "Submit Invoice" & vbCrLf
Msg = Msg & "Copy your Manager"
MsgBox Msg, vbInformation, "Don't Forget"
End Sub

I want this message to pop up when the work book is opened.
right now it only works if I run the macro. thanks