View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default Macro "not to check compatibility when saving this workbook"

maybe try adding

Application.DisplayAlerts = False

just prior to the code that saves the file

"fruitchunk" wrote:

I recorded a macro in excel. it works fine but stops before saving the file
and i get the "Compatibility Checker".
Is it possible to have it in the macro "not to check compatibility when
saving this workbook" ? I don't want to disable "Compatibility Checker" from
excel just for this macro.
Please help.