VBA - Left Shift to be Activated when Sheet is selected.
 

VBA - Left Shift to be Activated when Sheet is selected.
I would like have the Left Shift to be Activated (Down) when a Perticular WorkSheet is selected.
I would also like to know if it's possible to trap KeyDown Events or Mouse Click Events in a WorkSheet?
Does anyone have any suggestions?

thanks
Brad

VBA - Left Shift to be Activated when Sheet is selected.
 

The SelectionChange event will capture selecting a cell. This would be
trigger regardless of the method of selection, but includes clicking the
mouse on a cell. Other than that, there is no built in event to capture
mouse events or keyboard event. You would probably need to subclass Excel
to get this type of control

Not sure what a Left Shift Activated would accomplish or how that would be
done. It isn't a toggle like Shift Lock or Num Lock.

--
Regards,
Tom Ogilvy

"BradWarr" wrote in message
...
VBA - Left Shift to be Activated when Sheet is selected.
I would like have the Left Shift to be Activated (Down) when a Perticular
WorkSheet is selected.
I would also like to know if it's possible to trap KeyDown Events or Mouse
Click Events in a WorkSheet?
Does anyone have any suggestions?

thanks
Brad