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!