Overcome Excel "Save as"

[mqdias]

Hi,

I have my own "save as" option in a command button. this control is made by a msgbox (YesNoCancel), but if my option is "No", i give command to close the workbook. But, if there were changes in the workbook , appears the Excel "Save as " message.

How can i overcome this "save as" Excel function, so that i can work only with my Save function and ignore Excel's one?

Thanks!

[Bob Phillips]

set the change flag

[vba]

ActiveWorkbook.Saved = True
[/vba]

[mqdias]

Thank you soo much!!

It worked fine!!