Thread: Msg Box Timer
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Msg Box Timer

Maybe I am missing something here...
Pressing the Shift key when clicking the Enable Macros button
disables the Open event.

Jim Cone
San Francisco, USA


"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!!