Thread: Excel Application Warinings and Errors
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Excel Application Warinings and Errors

Most warnings can be suppressed by turning off alerts:

Application.DisplayAlerts = False
' your code here
Application.DisplayAlerts = True

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com




On Sat, 6 Mar 2010 08:57:09 -0700, "PPL"
wrote:

Hi I'm trying to treat an Excel warning through VBA. Can this be done?
Excel Application errors or warnings don't seem to raise error codes in VBA
TIA
Phil

Reply With QuoteReply With Quote