Message box upon opening file

F

flipperdoodle

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?
 
M

Mike

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
 
F

flipperdoodle

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

Mike

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

flipperdoodle

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?
 
M

Mike

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