Is there a way to know when a worksheet has been clicked?

  • Thread starter Thread starter John
  • Start date Start date
J

John

I would like to know how I can program a worksheet before click event,
similar to a worksheet before doubleclick event or if there is a way
that can make me know when a worksheet has been clicked.

Thank you
John
 
Since clicking a cell selects it, maybe you could use the SelectionChange event. However, that
will be triggered when the user moves the cell cursor with the keyboard.
 
Myrna Larson said:
Since clicking a cell selects it, maybe you could use the SelectionChange event. However, that
will be triggered when the user moves the cell cursor with the keyboard.
Click to expand...

I forgot to say that the worksheet is protected and selection is
disabled. I want to avoid the ugly worksheet protection message, "The
cell or chart you are trying to change is protected and therefore read
only. To modify a protected cell or chart blah blah blah ..." that
pops up when a user tries to type on a protected worksheet
 
John,

Put this into a module or event module
ActiveSheet.EnableSelection = xlUnlockedCells
or
Sheets("mysheet").EnableSelection = xlUnlockedCells
this way the user can't select a protected cell.

steve
 
Back
Top