VBA to return to original active cell after running macro

[EssKayKay]

I’m looking for a way to return to cell that was last active prior to running a macro. That is, when a cell in a range (C3:C77) is active, a routine is triggered to test if a cell in that range is “locked”. If it is locked then a Sub is run to “unlock” the range.

I have this working except that after the range has been changed to “unlocked” the range remains highlighted. I can add a Range.Select command at the end of the unlock routine which removes the highlight but then the active cell is not where the user originally placed it but rather the Range.Select cell. After running the unlock routine, I want to return to the original active cell.

Thanks,
Steve

 

[Joe4]

First, capture the cell at the very beginning of your code with lines like this:

Dim c as Range
Set c = ActiveCell

Then at the very end of your code, select that cell you set at the beginning, i.e.

c.Select

 

[EssKayKay]

First, capture the cell at the very beginning of your code with lines like this:

Dim c as Range
Set c = ActiveCell

Then at the very end of your code, select that cell you set at the beginning, i.e.

c.Select

Excellent. Thank you Joe - that did.
Much appreciated. . .

 

[Joe4]

You are welcome.