Thanks Bob this is ok now.

so do i just use thisWB to refernce in any code i am writting?

i.e Windows(thisWB).Activate

would i need to add anything else?

Sorry to bug you like this but it is the only real way that i am goin
to learn. Beacuse of the questions i have been asking over the past fe
months i am going to list all the refeneces on my site for othe
newbies to us

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