Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel event handler Worksheet_SelectionChange
Re : Excel event handler Worksheet_SelectionChange
1. Having made use of an event handler, Private Sub Worksheet_SelectionChange(ByVal Target As Range). 2. For example ; Commence selection at cell A1 ; right-click to show short-cut menu and select Copy. 3. Next, select cell B1 ; right-click to show short-cut menu ; but, the menu items Paste and Paste Special were dimmed (in effect, it's rendered powerless). 4. That means that it ain't able to carry out the regular recipe of Copy-and-Paste. 5. The requirement is, Copy-and-Paste operations should be restored ; Please enlighten. 6. Otherwise, how to circumvent the suspension of Copy-and-Paste ? What is the viable and amicable alternative to achieve the same ? 7. Regards. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel event handler Worksheet_SelectionChange
Post your Worksheet_SelectionChange event. Solving the
problem without knowing what your code contains is very difficult. I use Worksheet_SelectionChange all the time, and never have problems with copy/paste. -----Original Message----- Re : Excel event handler Worksheet_SelectionChange 1. Having made use of an event handler, Private Sub Worksheet_SelectionChange(ByVal Target As Range). 2. For example ; Commence selection at cell A1 ; right- click to show short-cut menu and select Copy. 3. Next, select cell B1 ; right-click to show short-cut menu ; but, the menu items Paste and Paste Special were dimmed (in effect, it's rendered powerless). 4. That means that it ain't able to carry out the regular recipe of Copy-and-Paste. 5. The requirement is, Copy-and-Paste operations should be restored ; Please enlighten. 6. Otherwise, how to circumvent the suspension of Copy- and-Paste ? What is the viable and amicable alternative to achieve the same ? 7. Regards. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet_change event handler error | Excel Discussion (Misc queries) | |||
What code do I use to attach event handler that will open my user. | Excel Worksheet Functions | |||
Where?Worksheet code module or Worksheet_SelectionChange event han | Excel Worksheet Functions | |||
Worksheet_SelectionChange Problem | Excel Discussion (Misc queries) | |||
Worksheet_SelectionChange not working | New Users to Excel |