Thread: message box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default message box

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...
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Hein" wrote:

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