If you do not want the cancel button then simple paste
Private Sub Workbook_Open()
MsgBox "Press Ok to continue"
End Sub
--
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