Thanks Paul. I had checked that and just checked it again. The macros are enabled as is "Trust access to the VBA project object model". I didn't think it was the security settings as my other macro works fine on the same document.