I have 12 spread sheets (12 files). I have set up a macro that can open them
all and copy the needed info and paste them in one single spread sheet, and
then closes them all. when the marco closes the opened spread sheet, it
alwasy ask me whether I want to save the changes in the opened spread sheets.
I have to klick 12 times NO to this question. how can I avoid that. Note that
when the marco opens the spread sheets no changes will be made to them, hence
no need to save changes. is there any possible way to avoid this and close
the spread sheets without asking me to save changes? many thanks