Make sure you put the code under ThisWorkbook (and delete it from that General
module).

stuck wrote:

Thanks for that but i'm getting a syntax error at the 2nd line. i know
nothing about VB so i am just plugging this in and hoping it works. any
help wld be great.
thx

--

Dave Peterson