Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to know when a worksheet has been clicked?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to know when a worksheet has been clicked?
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. On 26 Jul 2003 21:14:05 -0700, (John) wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to know when a worksheet has been clicked?
Myrna Larson wrote in message . ..
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. On 26 Jul 2003 21:14:05 -0700, (John) wrote: 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 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to know when a worksheet has been clicked?
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 "John" wrote in message om... Myrna Larson wrote in message . .. 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. On 26 Jul 2003 21:14:05 -0700, (John) wrote: 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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clicked NO to save, should have clicked YES | Excel Discussion (Misc queries) | |||
HOW DO I GET AN X IN A CELL IN EXCEL TO COME & GO WHEN CLICKED | Excel Discussion (Misc queries) | |||
Clicked on no to save too soon | Excel Discussion (Misc queries) | |||
my chart is grey when not clicked on it. why? | Charts and Charting in Excel | |||
Determine when checkbox is clicked | Excel Discussion (Misc queries) |