Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros Stop Working
Is there any known condition in Excel which
disables every macro, or sheet click/double click event etc etc ? I get this a lot and can't figure out what causes it. The fix is to close and re-open Excel and everything works again. But it would be nice to prevent it happening at all. Thanks - Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros Stop Working
Check whether in any of the macros you have set
Application.EnableEvents to False and then missed to reverse it to True If this post helps click Yes --------------- Jacob Skaria "kirkm" wrote: Is there any known condition in Excel which disables every macro, or sheet click/double click event etc etc ? I get this a lot and can't figure out what causes it. The fix is to close and re-open Excel and everything works again. But it would be nice to prevent it happening at all. Thanks - Kirk |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros Stop Working
Are you opening any workbooks programmatically and doing something else?
I've had this happen when I pressed the SHIFT key. http://www.jkp-ads.com/Articles/WorkbookOpenBug.asp "kirkm" wrote: Is there any known condition in Excel which disables every macro, or sheet click/double click event etc etc ? The fix is to close and re-open Excel and everything works again. But it would be nice to prevent it happening at all. Thanks - Kirk |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros Stop Working
On Fri, 1 May 2009 19:45:02 -0700, Barb Reinhardt
wrote: Are you opening any workbooks programmatically and doing something else? I've had this happen when I pressed the SHIFT key. http://www.jkp-ads.com/Articles/WorkbookOpenBug.asp Thanks for the info... not sure if it applies or not. Yes I'm usually doing all kings of things and of course, you don't know it's going to happen until it does! Oh well... will box on! Cheers - Kirk |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros Stop Working
On Fri, 1 May 2009 18:58:01 -0700, Jacob Skaria
wrote: Check whether in any of the macros you have set Application.EnableEvents to False and then missed to reverse it to True They all seem right, but I'll try Application.EnableEvents = True in the debug window next time as see if it has any effect. Thanks - Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does this stop excell from working | Excel Programming | |||
Formulae stop working | Excel Worksheet Functions | |||
Why did this code stop working ? | Excel Programming | |||
My Excel stop working can any one help? | Setting up and Configuration of Excel | |||
Excel FUNCTIONS stop working | Excel Worksheet Functions |