As Paul has shown, the macro can be a single line of code. I included the extra lines to try to avoid possible errors should the object not exist or perhaps not be selectable.

Coding in Excel can also be written in few lines if you are happy to deal with errors when something unforeseen causes a problem.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Thanks for the help people. You guys have taught me a lot and thanks for showing me different ways to approach my issue with the document.