Thread
:
Break out of a loop in Excel2007?
View Single Post
#
6
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Break out of a loop in Excel2007?
That's why I put ??. Where is the loop?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Don" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett