Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Alex Meyer   on Dec 18 In MS Office Category.

  
Question Answered By: Binge Fischer   on Dec 18

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.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on possible to change Protected Sheet error message? Or get search suggestion and latest updates.


Tagged: