Actually I think I have just cracked it.

Need to restart Excel when after the code has been dropped in. Not sure why, but it seems to work.