turn off messagess
 

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


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

turn off messagess
 

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/new...rod_office&slc
id=US wrote in message ...
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


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

turn off messagess
 

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.

--
Jim Rech
Excel MVP