More 'Already Selected Fix' Ideas. When the user wants to select a
cell that was selected when the sheet was saved. In the BeforeSave
event handler, change the cell selection - forcing the user to
re-select and therefore fire the Selection_Change.
If this is awkward because the user may not remember where he was.
Go ahead and change the selection BeforeSave, as above, but
remember/save the cell(location/address) the user had selected in a
cell on a hidden sheet. When the workbook opens, pop up a UserForm
that asks the user if he wants to resume where he left-off. If the
answer is Yes, let VBA re-select his cell (leave events enabled) and
let the Selection_Change fire. Your data entry UserForm will pop up
as usual.