Ok i have resolved this myself!!
But i have no idea where it was in this state.

But basically it wasn't in design mode?
I have to click design mode at the top then this behavior stopped.
But if i had just created a macro it wouldnt be in design mode from the start!
Stupid Excel!