Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've been working on this file all day, then i closed it, went to lunc
and when i came back i opened it again. now, every time i open it get the microsoft error - the one that asks to send the report or don' send it. WHAT THE WORLD! when i hit don't send, it tries to recover th workbook, but none of the macros are there. any thoughts -- Message posted from http://www.ExcelForum.com |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Either open the workbook while holding the SHIFT key down, to stop macros
from processing, or set your security settings so that you're prompted to run the macros. That way, you can open it without running the macros, and you can take a good look at your open routines. Stan Scott New York City "ForSale " wrote in message ... I've been working on this file all day, then i closed it, went to lunch and when i came back i opened it again. now, every time i open it i get the microsoft error - the one that asks to send the report or don't send it. WHAT THE WORLD! when i hit don't send, it tries to recover the workbook, but none of the macros are there. any thoughts? --- Message posted from http://www.ExcelForum.com/ |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Stan
i opted to disable the macros from running, and it still happened a soon as it opened. i have tried this on another machine with the sam response -- Message posted from http://www.ExcelForum.com |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() also try: in vbe immediate: application.enableevent=false (to disable eventhandlers from compiling (and crashing) then open your workbook. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam ForSale wrote : Thanks Stan i opted to disable the macros from running, and it still happened as soon as it opened. i have tried this on another machine with the same response. --- Message posted from http://www.ExcelForum.com/ |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks, however, it still crashed when i opened it with the event
enabled. The one thing that i noticed this time was that on the top bar it sai 'Microsoft Excel - Skill Grid [Group]' it's never had the [Group] part before. and it seems like it opene two of the same file, not sure. down on the task bar there are tw Excels with the same name. maybe one of those is the error. weird that this worked before i ate at Subway... any other ideas? it' -- Message posted from http://www.ExcelForum.com |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() can you mail the offender?..zip it first please? -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam ForSale wrote : any other ideas? it's |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Entry error In Microsoft Excel 2000 | Excel Worksheet Functions | |||
Date Entry error In Microsoft Excel 2000 | Excel Worksheet Functions | |||
Microsoft Visual Basic Error in Excel | Excel Discussion (Misc queries) | |||
Microsoft Excel import a webpage error | Excel Discussion (Misc queries) | |||
Error using "IF" in Microsoft Excel | Excel Worksheet Functions |