Message box upon opening file

[Guest]

I would like to create a message box that pops up when you open my file that
contains a message and the user has to click OK to close the box to proceed.
Similar to the gray box that pops up when opening a file that is password
protected....Help anyone?

 

[Guest]

Try this flipper
Private Sub Workbook_Open()
MsgBox "I would like to create a message box that pops up when you open my
file that" _
& "contains a message and the user has to click OK to close the box to
proceed." _
& "Similar to the gray box that pops up when opening a file that is
password" _
& "protected....Help anyone?"

End Sub

 

[Guest]

Hi Mike. Is there some type of crazy way to ready this message? I am not
sure I understand....

 

[Guest]

Sorry try this
Private Sub Workbook_Open()
MsgBox "I would like to create a message box"
End Sub

 

[Guest]

Ok...where do I enter the info below? Is it a macro? A formula?

 

[Guest]

Flipperdoodle
You need to place that into the thisworkbook module

 

[Guest]

This worked GREAT! Thank you! One more question....Now, this file is saved on
a shared drive. When I open it, the message box works. When someone else
opens it, it does NOT work. How do I fix this?

 

[Guest]

Did you happen to put this into your personal .xls workbook instead of the
workbook
that is shared