Macro "not to check compatibility when saving this workbook"

  • Thread starter Thread starter fruitchunk
  • Start date Start date
F

fruitchunk

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.
 
maybe try adding

Application.DisplayAlerts = False

just prior to the code that saves the file
 
Application.DisplayAlerts = False
SEt at the beginning of your code to stop it from asking during execution,
but if you don't want to completely disable it, you must set it back to true
at the end of your macro.
Application.DisplayAlerts = True

--
If this posting was helpful, please click on the Yes button on the bottom
right of this window.
Regards,

Michael Arch.
 
Back
Top