Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
recalculation - saving
each time my macro copies a cell from one workbook to
another workbook, excel saves both files. Is there a way to stop this type of saving activity??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
recalculation - saving
Paul
Don't really understand, but if you are trying to not save the originating workbook then either (Psuedo code) The first closes it without saving, the second marks it as saved (Clean) and therefore you don't get asked. Workbooks("Originating").Close SaveChanges:=False OR Workbooks("Originating").Saved = True If you are simply looking to not display the dialogs. (Excel will take the default decision) then Application.DisplayAlerts = False and switch to True before *any possible* exit -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Paul" wrote in message ... each time my macro copies a cell from one workbook to another workbook, excel saves both files. Is there a way to stop this type of saving activity??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
recalculation - saving
Try posting your code. If we can't see you code we can't answer your
question |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recalculation | Excel Worksheet Functions | |||
recalculation | Excel Discussion (Misc queries) | |||
Recalculation | Excel Worksheet Functions | |||
Recalculation | Excel Discussion (Misc queries) | |||
Too much recalculation | Excel Programming |