message box

  • Thread starter Thread starter Hein
  • Start date Start date
H

Hein

I want a message to display on a worksheet when a file is open. The message
must contain an OK button that must be pressed by the user. On clicking the
OK button the message box must dissappear.

Can somebody please assist.
Thanks
 
Open Workbook
Press Alt-F11 to open VBE editor
Click on This workbook under your workbook
Paste the following
'----------------------
Private Sub Workbook_Open()
MsgBox "Press Ok to continue", vbOK
End Sub
'-----------------------
Close VBE
Close your workbook

Open again to test...
 
If you do not want the cancel button then simple paste
Private Sub Workbook_Open()
MsgBox "Press Ok to continue"
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Providing user message when RED X clicked & properly closing application. 2
Urgently help needed - dropdown box does not show up 1
warning message 2
Oversensitive touchpad on modern laptops 0
Message Box on exiting workbook 1
excel 2003 print error number must be between 1 & 32767 1
Pop up message on Worksheet 3
IPad remote 10

Back
Top