I have a workbook that I keep date material in.
I am willing to have it open all day long to accomodate this but what I
want is for a window to pop up when a condition is met within the sheet
(e.g. a time of day is reached) without restoring the wrkbk.

Ideally the workbook does not have to be open but I realize that may be
asking a lot.

Thanks in advance.

Finn

Hi,

You can schedule a macro in Excel. In the following example, the macro runs
at 9:45 AM if Excel is open and is in ready mode. The OnTime method of the
Application object schedules "Macro1" to run at 09:45 AM. If you open this
file run this macro at say 7:30 AM and save/close the file but keep Excel
running, the file will automatically open at 9:45 and "Macro1" will run. You
can experiment with this idea a bit more to get the desired effect.

Sub ScheduleAMacro()
Application.OnTime TimeValue("09:45:00"), "Macro1"
End Sub

Sub Macro1()
MsgBox "It is time to run this macro."
End Sub

--
Anant


"Finny" wrote:

> I have a workbook that I keep date material in.
> I am willing to have it open all day long to accomodate this but what I
> want is for a window to pop up when a condition is met within the sheet
> (e.g. a time of day is reached) without restoring the wrkbk.
>
> Ideally the workbook does not have to be open but I realize that may be
> asking a lot.
>
> Thanks in advance.
>
> Finn
>
>

Thanks Anant, that is a cool function.
looking for the desktop alert...

Anant Basant wrote:
> Hi,
>
> You can schedule a macro in Excel. In the following example, the macro runs
> at 9:45 AM if Excel is open and is in ready mode. The OnTime method of the
> Application object schedules "Macro1" to run at 09:45 AM. If you open this
> file run this macro at say 7:30 AM and save/close the file but keep Excel
> running, the file will automatically open at 9:45 and "Macro1" will run. You
> can experiment with this idea a bit more to get the desired effect.
>
> Sub ScheduleAMacro()
> Application.OnTime TimeValue("09:45:00"), "Macro1"
> End Sub
>
> Sub Macro1()
> MsgBox "It is time to run this macro."
> End Sub
>
> --
> Anant
>
>
> "Finny" wrote:
>
> > I have a workbook that I keep date material in.
> > I am willing to have it open all day long to accomodate this but what I
> > want is for a window to pop up when a condition is met within the sheet
> > (e.g. a time of day is reached) without restoring the wrkbk.
> >
> > Ideally the workbook does not have to be open but I realize that may be
> > asking a lot.
> >
> > Thanks in advance.
> >
> > Finn
> >
> >