Bob,

Based on the current code, it will run at 9.15. The 15 minute interval is
working beautifully. 'MsgBox "FirstTimer is " & FirstTime' placed in the
StartTimer before "If FirstTime Then" always return false regardless of the
time.



"Bob Phillips" wrote:

How about adding a test that if it is opened between 9:00 and 9:15, run the
macro and schedule the next at 9:15.

--