Hi Firefytr,

Just out of curiosity, aren't you supposed to post a little more details of where the code is erroring out? Maybe your Excel version? :rofl

Seriosuly though, reading Ivan's code generally takes me though a 4 step process...


I'm stuck between 2 and 3 right now...

I did notice from Ivan's post that he refers back to the ExtremeVB post where some of the code comes from... http://www.visualbasicforum.com/showthread.php?t=160978
In his original version, the IsFileOpen and LastUser functions were separated, and he's consolidated them in the post that is on his site. I wonder if you may want to split it up to pin down the issue a little further.

I am curious to see an answer on this as well. And why are there # signs in If/Then/Else statement?

Cheers,