Use save instead of saveas.

--
Regards,
Tom Ogilvy

"Celtic_Avenger " wrote in
message ...
Hi Peeps........Can you help?

I have recorded a simple macro in the "Before Close" section of the
sheet, to save all work before the sheet closes,

However I have also created a active control button in one of the
sheets to save the workbook and then close it.

I need to keep both codes as they operate at separate times,

When I click the save and close button, it does all that I want
including Saving the file, after saving it then closes the work book,
but before this a pop up message asks me that a file allready exists
with the same name, do I want to overwite?

Is there any way I can stop this from poping up?


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