Thread
:
Program Auto Yes for overwriting files
View Single Post
#
2
Posted to microsoft.public.excel.programming
Die_Another_Day
external usenet poster
Posts: 644
Program Auto Yes for overwriting files
before save use this line of code:
application.displayalerts = false
after saving turn it back on with this line of code
application.displayalerts = true
HTH
Die_Another_Day
Reply With Quote
Die_Another_Day
View Public Profile
Find all posts by Die_Another_Day