Not sure if anyone else has this problem but my macro security settings are all set to 'medium' however if I try to open a file via Explorer, the macro's will not run and a message comes up saying the security is set too high even though when checking the file, they are still set on meduim.
When opening the file with Excel, the enable macros option comes up and then they will run.