Thanks for that.

What you have shown me will allow the macro to be run in 7 days fro
the date given. I would like the macro to run once a week until it i
stopped automatically.

This section of the vb coding:

Application.OnTime Date + 7 + TimeSerial(15,0,0), "Refresh"

: will only allow the macro to run again in 7 days time. I will the
want it to run 7 days after that and then 7 days after that unti
stopped.

Is that possible

--
Message posted from http://www.ExcelForum.com