dissable my own msgbox

[wilg]

I have some code that when the sheet calculates a msgbox will pop up.

I have another piece of code I want to run but would like to temp dissable my own code for the msgbox that pops up.

I tried application.displayalerts= false but didn't seem to work.

Am I missing something?

[Bob Phillips]

AS your code invokes the MsgBox, you will have to code the logic that determines not to invoke it.

[mbarron]

This can be accomplished turning Application Events off then back on.

[VBA]Application.EnableEvents = False
'the code that would trigger the calculation event to fire
'goes between the Application.EnableEvents lines
Application.EnableEvents = True[/VBA]