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???
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???
That's very strange behavior. I've never seen it, and I do A LOT of VBA programming in Excel.
Can you paste some of your code here?
- Pete
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
[email protected]HIS
"Paul" <[email protected]> wrote in message
news:[email protected]...
> 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???
Try posting your code. If we can't see you code we can't answer your
question
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks