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