where to place undo-function in vsto-projects?

[Guest]

hi.
I am having a C# Excel-Workbook project (VSTO) in which I would like to undo
a self-made function with the Application.OnUndo functionality.
My problem is, that I don't know where I should place the function which
should be called. When I click the Undo-Button in Excel an error-msg appears
saying the macro cannot be found.

I tried to place the function in different locations but it didn't work
until now. Any suggestions?

 

[Norman Jones]

Hi Cribe,

Have you tried placing the undo procedure in a standard module? Doing so, I
experienced no problem.

 

[Guest]

the problem is, i don't know where/what the standard module is in the c#
workbook-project (which class represents the standard module?).

 

[NickHK]

If you mean that you are writing your .OnUndo routine to the project from
your C# code, you will need to work with the VBE.
Here's a VB example:
http://www.cpearson.com/excel/vbe.htm

NickHK

 

[Guest]

so you think it's not even possible to call a c# function?