macro question

[barb]

have a macro that opens up another wrksheet and copies a
column and pastes it in my wrk sheet and closes
the other file and does not save changes. My question
is ....is there a way to do this w/out after i do the
macro i get the do you want to save changes prompt. i did
that in the macro so shouldn't that be enough, it is
irritating.


thanks

 

[Frank Kabel]

Hi
use
application.displayalerts=false
'your code
application.displayalerts=true

 

[barb]

thanks it works great

-----Original Message-----
Hi
use
application.displayalerts=false
'your code
application.displayalerts=true

--
Regards
Frank Kabel
Frankfurt, Germany


.