Prevent Macro to run Macro on Worksheet.Change

[akyhne]

I have a sheet with some cells that calls some macros with (Example):

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Name.Name = ("A1") Then

<something>

End Sub

I allso have some Macros that changes the value on ("A1")
When theese Macros want to change cell A1 the worksheet.change should be
ignored or the Code should look something like this:

If Target.Name.Name = ("A1") And Worksheet.Onkey = True Then

<something>

End Sub

 

[Rog]

Prevent your macros from firing the events like this :

Application.EnableEvents = False

'your code to change cell values

'turn on events at end of code

Application.EnableEvents = true

Rgds

Rog

 

[akyhne]

This is only an example. Cell A1 is in a lot of places. As I wrote I have
some Macros that changes A1. In theese Macros I use Application.EnableEvents.
then I have to Write Application.EnableEvents = False just after i changed A1
in my Macros.
No good!!!

"Rog" skrev:

 

[Rog]

I think maybe you're overcomplicating things

All you need to do is to disable the events in your "top
level" macro, and enable them again just before this macro
exits. It then won't care about how many times cell A1 or
any other cell is chaning in the code between the
statements.

This is the easiest way to do it.

Rog