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.