| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
message box
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
message box
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Message Box | Excel Discussion (Misc queries) | |||
| Message Box | Excel Discussion (Misc queries) | |||
| Message | Excel Worksheet Functions | |||
| Add a Message Box | Excel Worksheet Functions | |||
| changing the message in an error message | Excel Worksheet Functions | |||
Linear Mode
