If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Macro to move back to previously active cell

Hi there

Is anyone able to write a macro that allows the user to return to the cell that was last active. I want to be able to use a shortcut that returns me to the cell through which I have followed a link (by using CTRL + [). I have given it a go but am struggling.

I did something similar for a client who wanted a "Back" button which would take the user to the previously selected sheet. This could be modified to go to the previous sheet and also the cell:
I put this code into every sheet in the workbook:
[VBA]Private Sub Worksheet_Activate()