Exit Private Subroutine

[longbow007]

Hello, could some one please help me with the following:

When I run the Sub Data_to_Text() macro (in Module 1) and the following part of the macro is being executed:

Please Login or Register  to view this content.

Excel 2003 also runs Private Sub Worksheet_Change(ByVal Target As Range) subroutine located in the Sheet 1 (Data) Microsoft Excel Object for each cell that the user has selected in the Worksheet named "Data".

Is there a way to exit the private subroutine instead of running through most of the code?

I have attached a copy of the spreasheet with "dummy-data".

Any help is greatly appreciated.

Kind regards,

Chris

Please Login or Register  to view this content.

[Marcol]

Put

Please Login or Register  to view this content.

At the point you want to exit
eg

Please Login or Register  to view this content.

This will stop if x=y and run on if not

[Marcol]

Another possibility

To prevent a macro triggering a change event

Please Login or Register  to view this content.

This will allow a macro to change a cell and bypass Private Sub Worksheet_Change

[longbow007]

Another possibility

To prevent a macro triggering a change event

Please Login or Register  to view this content.

This will allow a macro to change a cell and bypass Private Sub Worksheet_Change

Hi Marcol, thanks for your help, but could you please advise what

Please Login or Register  to view this content.

code I need to prevent a macro triggering a change event besides:

Please Login or Register  to view this content.

Cheers,

Chris

[Marcol]

Hi Longbow007

' some code

Whatever code you need!

for example if this is your Sub

This will trigger Private Sub Worksheet_Change

Please Login or Register  to view this content.

This will not

Please Login or Register  to view this content.

Always remember to reset Application.EnableEvents =True
Otherwise Events will not happen until you do.

[longbow007]

Thanks again Marcol - very much appreciated.

Kind regards,

Chris.