T
TKT-Tang
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.
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.