Changing the active cell, switching worksheets, or window view will also
cause excel to display the message. there may not be any data that has
changed that will trigger the message.

"DocBrown" wrote:

Is there a way to determine what has changed in a workbook?

I have a template file I created. It has two worksheets and extensive
macros. When I open the file as a template and then close it, I get the
prompt 'Do you want to Save'. I'd like to find out what Excel thinks has
changed in the file so I can either change the code to not make that change
or save the file in the code so the prompt doesn't occur.

As a test, I disabled the Auto_open macro thinking something in the coding
was triggering the saved to be false. But the prompt persists. I'm continuing
to debug this but any insight would help greatly.

Thanks,
John