ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pop up message (https://www.excelbanter.com/excel-programming/375302-pop-up-message.html)

massi[_2_]

pop up message
 
i would like to have a pop up with a message when I open a spread sheet (like
a pop up of a web page for example)
is it possible to do it with excel?

Andy Williams

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



"massi" wrote:

i would like to have a pop up with a message when I open a spread sheet (like
a pop up of a web page for example)
is it possible to do it with excel?


Jim Thomlinson

pop up message
 
Make sure you put that code in the ThisWorkbook module otherwise it will not
fire. Right click the Excel icon next to file in the Excel menu and select
View Code. Paste the code there...)
--
HTH...

Jim Thomlinson


"Andy Williams" wrote:

Private Sub Workbook_Open()
MsgBox "This is a pop-up"
End Sub



"massi" wrote:

i would like to have a pop up with a message when I open a spread sheet (like
a pop up of a web page for example)
is it possible to do it with excel?


massi[_2_]

pop up message
 
thanks a lot!


"Jim Thomlinson" wrote:

Make sure you put that code in the ThisWorkbook module otherwise it will not
fire. Right click the Excel icon next to file in the Excel menu and select
View Code. Paste the code there...)
--
HTH...

Jim Thomlinson


"Andy Williams" wrote:

Private Sub Workbook_Open()
MsgBox "This is a pop-up"
End Sub



"massi" wrote:

i would like to have a pop up with a message when I open a spread sheet (like
a pop up of a web page for example)
is it possible to do it with excel?



All times are GMT +1. The time now is 09:04 AM.

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