I am trying to "force" my user to use the "save" subroutine i have written
which utilizes the GetSaveAsFilename method with a customized dialog and a
default filename. is there a way to bypass excel asking the user if they
want to save if they either try to close the workbook or click the save
button.
i attempted this already using the workbook_beforeclose event handler and in
that subroutine, put my getsaveasfilename method and it prompeted the user to
save again and when it went to close the workbook finally, ran through the
beforeclose event handler again. any help is appreciated, TIA