C
csdjj
Hi all,
This one is a bit confusing but I'll try my best to explain clearly. Here's
the situation:
1. I have an Excel workbook that contains certain macros.
2. I have created a scheduled task to open the workbook (and perform the
macros) once a week.
3. In order to allow it to be truly automated, I have set
Application.DisplayAlerts = False which works fine.
4. On occasion, however, I might want to get into the file without running
the macros. I have set up a message box for this a la:
If MsgBox("Do you want to run the macros?", vbYesNo, "Macros") = vbYes
Then MacRun = True
If Not MacRun Then Exit Sub
The problem is, if I use this message box, then it will prevent the
scheduled task from running.
My idea for a solution is to have a time delay on the message box that says
- if it's not answered within 10 seconds, then Excel will automatically
select "yes" to it.
Is this possible? If so, can someone tell me how to do it?
Thanks!
This one is a bit confusing but I'll try my best to explain clearly. Here's
the situation:
1. I have an Excel workbook that contains certain macros.
2. I have created a scheduled task to open the workbook (and perform the
macros) once a week.
3. In order to allow it to be truly automated, I have set
Application.DisplayAlerts = False which works fine.
4. On occasion, however, I might want to get into the file without running
the macros. I have set up a message box for this a la:
If MsgBox("Do you want to run the macros?", vbYesNo, "Macros") = vbYes
Then MacRun = True
If Not MacRun Then Exit Sub
The problem is, if I use this message box, then it will prevent the
scheduled task from running.
My idea for a solution is to have a time delay on the message box that says
- if it's not answered within 10 seconds, then Excel will automatically
select "yes" to it.
Is this possible? If so, can someone tell me how to do it?
Thanks!