Dear Graham



Thanks for your help. The document, saved as a macro-enabled document, runs the macro automatically upon opening.

I do, however, get an error when the document opens (see attachment) and I am not sure why. If I ignore the error and click on "End", the document opens and the macro has been run correctly. If I click on "Debug" it takes me to the VBA screen and highlights a line in yellow (see attachment). As the macro appears to be working, is there a way to stop the error appearing? Or perhaps incorporate the clicking of "End" into the macro?

By the way, I have slightly amended you macro code to reflect a change in table cell position and text of the target items.

Kind regards.

Taryn

Attached Files

Error upon opening word document.docx (47.6 KB, 10 views)