Yes, you can watch the individual saves take place in the status bar, and
the dates in A1 change; but when it reaches the last day of the specified
month, A1 is blanked out (because I added the .Value="" statement I posted
about earlier), the CommandButton becomes visible again and the worksheet
remains open. When I do close the template (manually), it asks me if I want
to save the changes to which I reply "No" (that way the template remains
every time I open it).

Rick


"Daniel" wrote in message
...
Quick question for you. When you run it, does it update your current
workbook? For example, when I run it for 4, I can watch it save on the
task
bar and the dates change in cell A1 until it gets to the last day where it
stays.

- Daniel

"Rick Rothstein (MVP - VB)" wrote:

Your Master Template closes all by itself? What is the extension on your
Master Template file? I did all my tests on files with .xls as the
extension
and did not see what you are describing.

Rick