Check out Application.EnableEvents
You may need this within your macro  if the macro itself causes the
worksheet to recalculate more than once. Often, when a macro is fired
by an event  it is a good idea to include the line
Application.EnableEvents=False somewhere near the start of the macro,
not forgetting to restore the status quo with
Application.EnableEvents=True
towards the end of the macro.