Quote Originally Posted by losinj
Is that the same as having[vba]Me.Saved = True[/vba]in the workbook's private module? If so it didn't seem to stop the prompt the last time I tried it. I'll have another go.
Yes it is, but only if it is in the ThisWorkbook module. Not just any module.

CreganTur is correct about it being a shorthand for where the code is behind and it is only applicable to Class modules which include: ThisWorkbook, Worksheet, Userform modules, and (obviously) Class Modules.

EDIT: I believe I should have said "Sheet" modules (to include Worksheets and Charts)