Hi
'...
application.displayalerts=false
activeworkbook.saveas "filename.xls"
application.displayalerts=True
'...

--
Regards
Frank Kabel
Frankfurt, Germany

"ForSale " schrieb im
Newsbeitrag ...
i feel i should know the answer, but i can't think of it for some
reason. when saving as, how do i save get it to save over the
orignal
file without displaying the alert message?


---
Message posted from http://www.ExcelForum.com/