I'm truly grateful for all who tried to help - and I'm blushing red when I examined the added code that prevented VBA from running.

Copied code for a module which was placed at the start - unfortunately it used [ ] instead of ( )!

Apologies for wasting your time. Thanks again.