I was also taken with the sensitive application, but, here's my solution

I have a number of things to save that I think of a Preferences. I
set up another, hidden, sheet that holds them.

In the Selection_Change Sub you save the current cell and sheet
location, in the Preference sheet (I use NamedRange Cells) every time
there is a change. If I recall, Target has the cell just exited and
ActiveCell is the one changed to. Then, when you do your emergency
save, it saves right along with the workbook.
When that workbook is opened again; in the Workbook_Open sub, you
get those Preferences and go back (Activate) that sheet/cell.
For multi OPs, you'll need to have some sort of log-in upon
Workbook Open which picks different locations for the Preferences in
the hidden data sheet. This sounds like a UserForm to me