recalculation - saving

[Paul]

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

 

[Nick Hodge]

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
(e-mail address removed)

 

[gopher]

Try posting your code. If we can't see you code we can't answer your
question