Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I transform a word response to a numeric response? | Excel Discussion (Misc queries) | |||
How do I set up a daily call out response response register? | Excel Worksheet Functions | |||
NAMES DEFINED | Excel Discussion (Misc queries) | |||
Defined Names | Excel Programming | |||
Using defined names in VBA... | Excel Programming |