Thanks for the suggestion on Chip Pearson's website.
I've managed to write the code to detect VBA contained
within sheets. However before it can run it requires that
I make a change to the references section contained in the
tools dropdown of the VBE. Chip discusses this.

Anybody know how to do this as part of the code so that
people who run my tool can have this change done
automatically..??

Chris