Hi Bob,

Thanks for the assist, but no luck with turning DisplayAlerts off.

Les

"Bob Phillips" wrote:

Haven't tried it myself, but try

Application.DisplayALerts = False

before the save and reset afterwards.

--
__________________________________
HTH

Bob

"LA-Alc" wrote in message
...
Hi all,

Have a macro that takes a .xlsm file and then saves it back to a '97-2003
.xls file. During the save, the following message shows:

"Defined names or formulas in this workbook may display different values
when they are recalculated in an earlier version of Excel if they:

- Reference cells outside of the row and column limit in an earlier
version
of Excel
- Include functions that are not supported...
- Use formula limits that are not supported in ....

Do you want to recalculate all formulas when this workbook is opened?"

What code can I put into the macro to automatically answer 'Yes' to this,
or
bypass it completely?

Thanks for any assistance.