View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ManualMan ManualMan is offline
external usenet poster
 
Posts: 35
Default disable warning messages?

Yep!

Application.DisplayAlerts = False

....your code

Application.DisplayAlerts = True

This will only disable workbook-related dialogs (Save / Discard, etc).
Errordialogs generated because of misprogramming etc require a more
solid error handling. Try googling "error handling syntax vba"
Manual Man