ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pop up message (https://www.excelbanter.com/excel-discussion-misc-queries/161423-pop-up-message.html)

Jhadur

Pop up message
 
Is there a way to have a pop up message flash to users whenever they open a
specific excel file?

Gord Dibben

Pop up message
 
Private Sub Workbook_Open()
MsgBox "This is a message"
End Sub

Copy/paste into Thisworkbook module by right-click on Excel Icon left of "File"
on menu bar and "View Code".


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 07:58:03 -0700, Jhadur
wrote:

Is there a way to have a pop up message flash to users whenever they open a
specific excel file?




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

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