Cheers Tom,
The forms toolbox works although I will stick with the autoshape arrow this
time. I'm not sure about the chart not closing as the same macro runs on the
Workbook_Open() event without problem. When the user selects a chart I am
running some code to unprotect and update the linked pivottable as this
ensures the chart is refreshed and then protected before the end-user can
accidentally delete it (they do). I'll go through that as perhaps the
answer is within that piece of code.

Thanks again,
Mickey