If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
supressing the message box
I have an excel macro which has some msgboxs with relevant messages
according to some business rules. I want to display these conditionaly only when the function is invoked by clicking on a button. I dont want these msgs to appear when the macro is run from a .vbs file. Is there any way to accomplish this? Pls let me know - ill be greatly benifited by it. Thanks! - Anu |
#2
|
|||
|
|||
supressing the message box
Is there a way of setting a variable to handle this? (Perhaps in a
worksheet cell) eg:- '-------------------------------------------------------------- Dim ShowMessage As Boolean ShowMessage = True If ShowMessage = True Then Msgbox( .......................... '-------------------------------------------------------------- --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|