since you schedule it to run why not check the time and it it isn't the
scheduled time, then exit.

Private Sub Workbook_Open()
if time < TimeValue("10:00 PM") or time TimeValue("11:00 PM") then
exit sub
end if
' current code
End Sub

--
Regards,
Tom Ogilvy

"Steph" wrote in message
...
Hello. I have a workbook with a Workbook_Open event in it that calls a
main
sub in the workbook. I am scheduling this code to run via the
Windows\Tasks
method. But, I would also like to manually open the file to perform work
on
it without the code executing upon opening. So I was thinking if there
was
a popup upon opening that would count down 30 seconds, with the "cancel
event" button on it. So I could open the file and hit cancel and the code
would not be called. If the popup times out 30 seconds, the sub would
then
be called. Is this possible?? Thanks!!