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!
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!