I have two questions:
I use a macro to find a row, and then use a hyperlink to go to the sheet I
want.
However, the sheet does not "Activate". I see the right sheet, but at the
bottom, the proper sheet is not highlighted. What do I need to add to
"activate" the sheet the hyperlink took me to?

In the same program, I call a macro in my consolidated workbook from the
workbook the data is in. The macro ends on the consolidated workbook, but the
display at the bottom is still showing the data workbook as being
highlighted. I want the consolidated workbook program to be highlighted.

Thanks!