Thanks again Bob. That also works, but again I have the same problem.
The macro that is called to perform when any of the sheets is selecte
first calls up the sheet on which the macro runs, then runs the macr
then that sheet remains as the active sheet. For example, the macr
that sorts the data for the vlookup function is on sheet "labor".
There are 3 other sheets, I'll call Sheet1, Sheet2 and Sheet3. No
when I click on say Sheet1, it goes to the "labor" sheet, runs the sor
macro, then stays right there. How can I make it so that it runs th
macro on "labor" sheet then returns to sheet1, the one I originall
selected? I do appreciate your help with this

--
moors
-----------------------------------------------------------------------
moorso's Profile: http://www.excelforum.com/member.php...nfo&userid=896
View this thread: http://www.excelforum.com/showthread.php?threadid=38050