turn off messagess

[excel programming]

Hi guys and girls,

There is a way to turn off any kind on message pop ups in excel. does
any one know how?
thank you

 

[Robin Hammond]

at start of code
application.displayalerts = false

at end of code
application.displayalerts = true

--
Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"excel programming"
<http://communities.microsoft.com/newsgroups/default.asp?icp=prod_office&slc
id=US> wrote in message news:%[email protected]...

 

[Jim Rech]

at end of code
application.displayalerts = true

At the end of code Excel automatically resets alerts. I don't think I've
ever used the above line of code. Did I ever want Excel alerts in the
middle of my code? I don't think so.