in the Preferences of Excel and Word under the Security section at the bottom it's got Macro Security - Warn before opening a file that contains macros
just tick that box and if you open a file which has Macros it'll ask you if you want to run them or switch them off.