P.S.

[Michelle]

That line that I've put in the previous message is in the 'Before_Save'
macro,
it is triggered by a line in the Before_Close macro that reads:
ThisWorkbook.Save

 

[BillyBob]

Michelle,

If you want to provide additional information to a previous post, then
respond to *your own* existing post. Don't start a new post with the
additional information. There could have been ten posts that arrived since
your last one.

BB