| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro "not to check compatibility when saving this workbook"
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro "not to check compatibility when saving this workbook"
Use this in 2007 and up
ThisWorkbook.CheckCompatibility = False ThisWorkbook.Save -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "fruitchunk" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro "not to check compatibility when saving this workbook"
Thanks for all your help.
P.S. Sorry about the duplicate posts, my mistake. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| Check if a workbook has an "open password" | Excel Programming | |||
| Can I keep "Windows of active workbook check box" checked | Excel Discussion (Misc queries) | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| Call a sub statement in "Personal Macro Workbook" from "ThisWorkbo | Excel Programming | |||
Linear Mode
