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.

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.
.