[SOLVED]
Thank you sweet (insert appropriate religious figure to your belief system here)!!!!
Finally figured this out. In the Macro Security tab, which I hadn't seen due to the developer tab wasn't activated, "Notifications for digitally signed macros, all other macros disabled" was CHECKED. I simply changed that to "Enable all macros....." and it went, like a dream.
Thank you for all your patience and advice. I'm exhausted
[SOLVED]