Yeah I had the code set like this

Application.EnableEvents = False
'code
'code
'code
'more code
Application.Run "MyMacro"
Application.EnableEvents = True

If I take out the EnableEvents line is works however know in my second
macro I have it creating a validation list in a cell that is offset
from the target. It works when I change the cell manually but when my
first macro changes the cell I get a runtime error '1004': Application-
defined or Object defined error. Any ideas why?