Ontime problem; variable not passed from Workbook_Open to Star
What about my suggestion?
--
__________________________________
HTH
Bob
"thomas" wrote in message
...
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.
--
|