OK, this is my last post until someone replies I promise! LOL

I did the above and all is working! Except... If someone left the form
with the cursor blinking in a cell. Like if you were to double click on
a cell it lets you type into that cell. Well, if it is like that then
the script will not execute until you leave that cell.
I have tried having the script change to a different sheet with no
luck. I've even tried sendkeys but that doesn't work either...

Any suggestions for this problem? I should probably start a new
thread...


--
clayton
------------------------------------------------------------------------
clayton's Profile: http://www.excelforum.com/member.php...fo&userid=4563
View this thread: http://www.excelforum.com/showthread...hreadid=492816