View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
thelemeuk thelemeuk is offline
external usenet poster
 
Posts: 4
Default compatibility mode checking Excel & VB

answer found in Excel Programming user group:

Try Application.DisplayAlerts = False
see:
http://www.microsoft.com/office/comm...s/settings.xml
Thanks

"thelemeuk" wrote:

How do I stop excel displaying a prompt to check for compatibility every time
I save a file in 97/2003 format from VB code?