Use Application.OnTime and set the time as below

Public dTime As Date

Sub MyMacro()
dTime = Now + TimeValue("00:15:00")
Application.OnTime dTime, "MyMacro"
End Sub

http://www.ozgrid.com/Excel/run-macro-on-time.htm

If this post helps click Yes
---------------
Jacob Skaria


"Elton Law" wrote:

Dear Expert,

I asked a question 2 weeks ago.
How to set the time macro.
Some has replied me and asked me to check following path.
That is useful.

http://www.brainbell.com/tutorials/m...A_Set_Time.htm

But now, I want to set a time marco which only run on specified time on
weekday only.
May I know how to write in VBA please ?
Thanks so much.