Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code still runing
Are you using OnTime for your timer? If so, the settings passed
to OnTime are global to the Excel application, and will only 'go away' when Excel itself is closed. When the timer pops, Excel will open the workbook containing the macro specified in OnTime and execute it. You should write your code such that the OnTime cancels itself when the workbook in question is closed. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DVallier" wrote in message ... I have VB code timer that shuts down a workbook after awhile. But if you close it early while any other workbook is open, the time (and code) still runs. I know this because the workbook re-opens when the timer runs out - only to close it. Has anyone run into this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code still runing
Thanks, Chip
I never thought of OnTime being global. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code still runing
I never thought of OnTime being global.
The fact that it is a method of the Application object is a good indicator that it is global to Excel and not part of an individual workbook. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Don Vallier" wrote in message ... Thanks, Chip. I never thought of OnTime being global. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
table with a runing clock | Excel Worksheet Functions | |||
Runing two macros triggered by a button | Excel Discussion (Misc queries) | |||
Runing two macros triggered by a button | Excel Discussion (Misc queries) | |||
error after runing MS update last weel 10/13/2005 | Excel Discussion (Misc queries) | |||
Automatically runing a macro | Excel Programming |