I need to set whatever indicator or key used by Excel that tells it a
workbook has been changed and prevents it from closing without asking if
I want to save it. Some of my macros make temporary appearance changes
to the workbook that I do not ever want to save and I would like to
reset the indicator so that when click on the 'red X', Excel will close.

I'm not sure if I have made my question clear.

Thank you very much.