thanks for that
"Paul B" wrote:
Roger, use something like this
Application.DisplayAlerts = False
'Your Save Code
Application.DisplayAlerts = True
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Roger" wrote in message
...
How do I get the macro to answer "yes" automatically when the Excel dialog
box comes up with the message "file name already exists - do you want to
overwrite?"
The reason is becasue I've got a number of files to save automatically and
i
don't want the user to have to keep hitting the "y" key.
--
Roger
|