Ahhh! The great "El Xid", nice to hear from you, Ken is assembling an Add In for me to get a workbook to automatically open another which performs various types of verification (as discussed in the many posts of this thread), he is also creating some code which checks for the Add In and if its not there re-install it provided the user is at work.

My posting above was me trying to be lazy and not opening all 27 workbooks and copying and pasting code in to them thats why i was lookiin at Chips code to do the job but i understand what was Ken was saying and will paste the code as he suggested.

But thanks for the suggestion.

Regards,
Simon