how to use Application.OnKey by C# without involving VBA code?

I want to use the UDF in excel template(.xlt) I have used Application.OnKey("^v","MyFunction");i want to use separate func开发者_StackOverflowtion when user paste the the cell in excel i.e. MyFuction but when i defined function with in the thisworkbook.cs i wont work...

Thanks in advance..

This won't work. You need to define the function in VBA and call you .NET method from that VBA function, like explained here at the end: http://msdn.microsoft.com/en-us/magazine/cc163373.aspx