Thanks, guys. I see what you are saying re being problematic...lots of good
suggestions on how to code or saving as a template. I'll work with these and
see what ends up working best for this particular worksheet. Appreciate your
quick responses - have a great day!!!.....Paige

"Fredrik Wahlgren" wrote:


"Jim Thomlinson" wrote in message
...
I like this solution, but this is going to require this workbook to be
saved
as something different every time you want to save. (On the other hand
that
is what Paige asked for). I have always liked your solutions so I was
wondering if you had a cool way around this... :)


Thanks! Well, I guess Paige could create a hidden command with this code

Application.EnableEvents = False
ActiveWorkbook.Save
Application.EnableEvents = True

/Fredrik