Urgent......How do customize the 'Paste'operation...
Posted by Kishan on January 03, 2001 12:12 PM
I have written a procedure 'Paste_Spec' to overwrite the
default Copy operation as follows:
This is for 'Edit-Paste':
CommandBars("Cell").Controls("&Paste").OnAction = "Paste_spec"
This is for Paste icon on the standard toolbar:
CommandBars("Standard").Controls("Paste").OnAction = "Paste_spec"
But in the excel sheet when I select the 'Edit-Paste' using mouse
the above 'Paste_Spec' procedure is not being fired.
Also how do I enable/disable Paste operation that appears in the
pop up menu when we right click the mouse button.
Anyone can please tell me why is it so.....
I need your urgent help........
THanks a lot.........