Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show msgbox only when....
Is there a way to show a msgbox only if the user opens the
workbook? The workbook is also opened by a script to update some data. I don't want the msgbox code to run if the workbook is opened from the script. tod |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show msgbox only when....
Tod,
Look at the UserControl property. E.g., If Application.UserControl = True Then MsgBox "Hello, World" End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tod" wrote in message ... Is there a way to show a msgbox only if the user opens the workbook? The workbook is also opened by a script to update some data. I don't want the msgbox code to run if the workbook is opened from the script. tod |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show msgbox only when....
Tod,
try Private Sub Workbook_Open() MsgBox "HI this message is open" End Sub cesar zapata "Tod" wrote in message ... Is there a way to show a msgbox only if the user opens the workbook? The workbook is also opened by a script to update some data. I don't want the msgbox code to run if the workbook is opened from the script. tod |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show msgbox only when....
Hey this is great! Perfect for what I need.
thanx "Chip Pearson" wrote in message ... Tod, Look at the UserControl property. E.g., If Application.UserControl = True Then MsgBox "Hello, World" End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tod" wrote in message ... Is there a way to show a msgbox only if the user opens the workbook? The workbook is also opened by a script to update some data. I don't want the msgbox code to run if the workbook is opened from the script. tod |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show Data validation List options in a msgbox | Excel Discussion (Misc queries) | |||
Show a message but not in MsgBox | Excel Discussion (Misc queries) | |||
msgbox | Excel Discussion (Misc queries) | |||
How do I format a MSGBOX to show text and variables in a macro? | New Users to Excel | |||
MsgBox | Excel Discussion (Misc queries) |