(First question only:) I don't use hyperlinks inside Excel much. (Actually I'm not sure I ever have, though I do it often enough in Word.) But when I experimented with it just now, the new active cell was in the upper left. Before I hit the link, the target sheet was several pages down from the top, and I made the target R13C2. I infer that Excel scrolled up to activate the new cell, and stopped once the new cell was visible. If I'm right, that implies that in your case the target sheet was active above the target cell, and had to scroll down.
...Further experimentation yields one solution for you: Set the target to a range, not a single cell. That causes Excel at least to scroll down enough to display the entire range. The entire range is selected, too, which may be a disadvantage....
|