Thanks Bob,

No i didnt get me closer!!....it got me spot on i can now integrat
that with the rest of my code. Your a life saver!

Sorry about reposting the message but i couldnt find you on the member
list to e-mail you so i had to try a different direction.

One other question, if you wouldnt mind?....the other macros i hav
running...well especially the Auto_close runs throught every sheet (2
of them) and updates the information in a range on each sheet (thi
operation is essential) the range it updates (update meaning it check
for entry and then adds a date if there is an entry in that cell to
cell 36 cells away, this is to keep track of who was trained when) als
happens to be the range that the code you kindly provided will work on
how do i turn of the worksheet code for each sheet in my Auto_close o
do i do it in each sheet code?

Simon

Once again Thanks!!!

Simon

--
Message posted from http://www.ExcelForum.com