Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When workbook is closed tries to reopen??
I have a workbook that, as part of its function, uses the onTime comman to refresh a particular sheet. When you exit the file however, it trie to reopen it ( a box with enable / disable macros) pops up again. I there a quick fix for this - a bit of code to stop all macros prior t closing ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
When workbook is closed tries to reopen??
You need to cancel the OnTime event procedure. See
www.cpearson.com/excel/ontime.htm for details. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "bdcrisp" wrote in message ... I have a workbook that, as part of its function, uses the onTime command to refresh a particular sheet. When you exit the file however, it tries to reopen it ( a box with enable / disable macros) pops up again. Is there a quick fix for this - a bit of code to stop all macros prior to closing? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
When workbook is closed tries to reopen??
I visited the site, and followed its instructions on ending ontime function but still have the same problem. I have 2 ontime events.. i tired disabling events, disabling timer (Setting schedule to false) but these do not seem to work. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
When workbook is closed tries to reopen??
Are you storing the time in a public variable? When you use
schedule:=false, you must provide the EXACT time that the timer was scheduled for. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "bdcrisp" wrote in message ... I visited the site, and followed its instructions on ending ontime function but still have the same problem. I have 2 ontime events.. i tired disabling events, disabling timer (Setting schedule to false) but these do not seem to work. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trouble with closed workbook | Excel Worksheet Functions | |||
GetValue - Closed Workbook? | Excel Discussion (Misc queries) | |||
Reopen workbook | Excel Discussion (Misc queries) | |||
Value from a closed workbook | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |