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???