View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LA-Alc LA-Alc is offline
external usenet poster
 
Posts: 1
Default Defined Names response


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.