Secutiry level "Medium" asks you whether to run the macro or not. If it is set to "High", then there is no prompting and the macro will not be executed.
Changing the settings to "Low" will run the macros without your permission, but not at all a good habit.