Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Break out of a loop in Excel2007?
I created some code that gets Excel in a loop when I open the file and I need
to know how to break out? It is in the Sheet option using the Application.EnableEvents in Office 2007 and will not let me break out of the loop and I have to close doing a cntl+alt+delete and hard crashing Excel. I have updated I think all the files, but if I have some not updated and people move to Office 2007, I would like another way to get out? Any help? see code below from the sheet Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Range(Cells(6, 6), Cells(7, 7)).Select Selection.ClearContents Application.EnableEvents = False End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Break out of a loop in Excel2007?
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Break out of a loop in Excel2007?
Change to:
Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Range("F6:G7")ClearContents Application.EnableEvents = True End Sub "Don" wrote in message ... I created some code that gets Excel in a loop when I open the file and I need to know how to break out? It is in the Sheet option using the Application.EnableEvents in Office 2007 and will not let me break out of the loop and I have to close doing a cntl+alt+delete and hard crashing Excel. I have updated I think all the files, but if I have some not updated and people move to Office 2007, I would like another way to get out? Any help? see code below from the sheet Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Range(Cells(6, 6), Cells(7, 7)).Select Selection.ClearContents Application.EnableEvents = False End Sub |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Break out of a loop in Excel2007?
Hi
You have to set EnableEvents = False before anything else, and set =true again later: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Range(Cells(6, 6), Cells(7, 7)).ClearContents Application.EnableEvents = True End Sub Best regards, Per On 1 Maj, 20:56, Don wrote: I created some code that gets Excel in a loop when I open the file and I need to know how to break out? *It is in the Sheet option using the Application.EnableEvents in Office 2007 and will not let me break out of the loop and I have to close doing a cntl+alt+delete and hard crashing Excel. * I have updated I think all the files, but if I have some not updated and people move to Office 2007, I would like another way to get out? Any help? see code below from the sheet Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) * * * * Range(Cells(6, 6), Cells(7, 7)).Select * * * * Selection.ClearContents * * Application.EnableEvents = False End Sub |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Break out of a loop in Excel2007?
thanks, but if I am in a loop, how can I get out?? I will change going forward. "Per Jessen" wrote: Hi You have to set EnableEvents = False before anything else, and set =true again later: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Range(Cells(6, 6), Cells(7, 7)).ClearContents Application.EnableEvents = True End Sub Best regards, Per On 1 Maj, 20:56, Don wrote: I created some code that gets Excel in a loop when I open the file and I need to know how to break out? It is in the Sheet option using the Application.EnableEvents in Office 2007 and will not let me break out of the loop and I have to close doing a cntl+alt+delete and hard crashing Excel. I have updated I think all the files, but if I have some not updated and people move to Office 2007, I would like another way to get out? Any help? see code below from the sheet Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Range(Cells(6, 6), Cells(7, 7)).Select Selection.ClearContents Application.EnableEvents = False End Sub |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Break out of a loop in Excel2007?
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Break out of a loop in Excel2007?
Hi Don
You can use 'Ctrl'+'Pause/Break' buton to break a running code... You can even give it a try...... If this post helps click Yes --------------- Jacob Skaria "Don" wrote: I created some code that gets Excel in a loop when I open the file and I need to know how to break out? It is in the Sheet option using the Application.EnableEvents in Office 2007 and will not let me break out of the loop and I have to close doing a cntl+alt+delete and hard crashing Excel. I have updated I think all the files, but if I have some not updated and people move to Office 2007, I would like another way to get out? Any help? see code below from the sheet Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Range(Cells(6, 6), Cells(7, 7)).Select Selection.ClearContents Application.EnableEvents = False End Sub |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Break out of a loop in Excel2007?
sorry, tried that an no luck.
"Jacob Skaria" wrote: Hi Don You can use 'Ctrl'+'Pause/Break' buton to break a running code... You can even give it a try...... If this post helps click Yes --------------- Jacob Skaria "Don" wrote: I created some code that gets Excel in a loop when I open the file and I need to know how to break out? It is in the Sheet option using the Application.EnableEvents in Office 2007 and will not let me break out of the loop and I have to close doing a cntl+alt+delete and hard crashing Excel. I have updated I think all the files, but if I have some not updated and people move to Office 2007, I would like another way to get out? Any help? see code below from the sheet Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Range(Cells(6, 6), Cells(7, 7)).Select Selection.ClearContents Application.EnableEvents = False End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros in Excel2007 | Excel Discussion (Misc queries) | |||
Need Help with Excel2007 | Excel Worksheet Functions | |||
excel2007 hotkey | New Users to Excel | |||
where is excel2007 installed? | Setting up and Configuration of Excel | |||
Break cell into multiple lines by line break | Excel Discussion (Misc queries) |