PDA

View Full Version : Overcome Excel "Save as"



mqdias
10-23-2007, 06:58 AM
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
10-23-2007, 07:19 AM
set the change flag



ActiveWorkbook.Saved = True

mqdias
10-23-2007, 07:35 AM
Thank you soo much!!

It worked fine!!:clap: