Are you sure the correct workbook was active when you tried to activate that
worksheet?

(If you're unlucky, then maybe there was a worksheet name that matched and you
just got the wrong one activated???)

wrote:

I appreciate your experience and comments. I am in fact unable to use
my computer effectively while my program is running.

I am opening up approximately 50 or so files one at a time, processing
data on from these files, adding charts and performing various
algorithms, and then saving the file as an xls. I use the
activeworkbook and activeworksheet throughout the code (errr).

anyhow, to answer your question, at the end of my program, I do change
screenupdating back to true before I apply worksheet.activate. What is
happening is that once my program begins, various worksheets in the
program become active, and upon termination, i want to user to start
off where he began. if there is another way, i'd be obliged to know
it.

Thanks.

Smokii

--

Dave Peterson