Hello Darren - thanks for the reply - I am using this in a VBA macro - but
I'm not familiar with the beforeClose event and forcing the save....so any
guidance on the coding would be greatly appreciated!

Thanks!

"darrenmcconachie" wrote:

Have you used VBA macros before?

In the ThisWorkbook module use the beforeClose event and force the
save. If you need help implementing this let me know. If there are no
macros already in the workbook this will create an extra question on
opening the book involving Macro security. There are 2 ways round this,
but let's deal with one question at a time!

Darren

On Oct 24, 1:47 pm, Matt wrote:
Is there a way to automatically answer questions that pop up as you are
manipulating files? For example, after performing specific functions to a
file, I have it close, but then the questoin comes up "Would you like to save
the changes you have made to file ABC?" - and the answer will always be
yes...so is there a way to code for that? Thanks in advance!