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

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

"Michelle" wrote in message
...
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