ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Opening Message (https://www.excelbanter.com/excel-programming/398789-opening-message.html)

Greg

Opening Message
 
When I open a workbook I would like a dialog box that has a message that
opens on the screen and the user has to click the ok button to clear the
message and start working. Any help would be appreciated.

Thanks in advance
greg

Sam Wilson

Opening Message
 
In the VBA editor right click on workbook and 'view code' change the right
hand box to say open and add the following:

Private Sub Workbook_Open()

MsgBox "Your text here", vbOKOnly, "Title"

End Sub


"Greg" wrote:

When I open a workbook I would like a dialog box that has a message that
opens on the screen and the user has to click the ok button to clear the
message and start working. Any help would be appreciated.

Thanks in advance
greg



All times are GMT +1. The time now is 01:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com