To add to Mick's suggestion, it would just be good programming practice
to set object refs in code to each open workbook your code acts on.
Usually, you would then not need to activate any workbook or worksheet
because your code knows which is which when you use object refs!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc