Hi.
I thank you both for your answers and both way's do work,(and work well).

However with cell protection and work sheet sharing that is turned on in differant work books neither way works for all. (i did fear this)

So i have try another approach which is seems to have to be to have a separate work book open and have the macro run from there, and have the data copied from closed work books into the separate open work book.

Any and all ideas and suggestion will be greatly appreiciated.