Hi,

I have the following VB Coding which activates macros on a regula
basis automatically, if Excel is left open.

Sub RunOnTime()
Application.OnTime Date + TimeSerial(15,0,0), "Refresh"
End Sub

Refresh is the macro which is being run.

The RunOnTime macro, activates the Refresh macro at 3pm every day.
Is there a way, or does anyone know, how I can get a macro similar t
this to run on a weekly basis rather than a daily basis as this on
currently does?

Thanks In Advance
Kiz

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