Hi e97h,

You could write a time to a cell in one of your worksheets using an On_Close event. Then when you open your workbook you could read that number to start the timer again from a non zero time.

If you don't want to use a cell in the workbook, how about using the Tag property in one of your objects and store the closing time there and read it on open?

Just some ideas...

Marv