Well Ken, i've been testing this finished product out at home (using 3 different drives) and the Control.xla is very efficient at checking every .xls that is opened regardless of drive!, only one snag.........if i remove any .xls and lets say copy it to another computer i get a pop up telling me that F:\Control.xls cannot be found blah blah! when i check the xls i moved i find that in the Add-In's Control is still checked, now the .xls that i moved is not in my list in Control.xla is there a way that if it does not exist in the .xla to uncheck the Control Add-in using the Control.xla authentication?

Other than that it works like a dream!

Regards,
Simon

Sorry for the delay in replying my broadband connection seems to have an authentication problem so i had to wait until i was at work!