hi
you probably have the code in a standard module. if you want the msbbox to
pop up when the workbook is opened, put in the workbook open module. in the
project window(far left) double click thisworkbook then from the left combo
of the code window, select this workbook. the workbook_open() should default

Regards
FSt1

"Marilyn" wrote:

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