![]() |
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 |
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