Worksheet_Change

[k209310]

I have a worksheet change function which automatically saves a worksheet every time that a name is entered in to a particular cell.

This function works fine. However every time a run another macro (i have several that gather requested information from databases) the macro again runs i assume due to the worksheet change function.

Is there a way around this little problem?

 

[Andrew Poulsom]

At the beginning of your "other macro" put:

Application.EnableEvents = False

and at the end put:

Application.EnableEvents = True

 

[Mudface]

Restrict your change procedure to only run when the particular cell is modified. For example, if you just want the procedure to run when cell A1 is changed, add the following at the start: -

If Target.Address <> "$A$1" Then Exit Sub
' Rest of your code

If your separate macro also modifies the cell, and you don't want the Change event to be triggered, then you could Application.EnableEvents = False at the start of your macro code, but make sure you set it back to True at the end.