where to place undo-function in vsto-projects?

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?

Hi Cribe,

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


--
Regards,
Norman



"cribe" <cribe@discussions.microsoft.com> wrote in message
news:D90DB2B9-FF65-497B-89F2-0B217CDD647E@microsoft.com...
> 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?

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

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

"cribe" <cribe@discussions.microsoft.com> wrote in message
news:4AFE4E38-8596-4389-8E49-5786F949EA52@microsoft.com...
> the problem is, i don't know where/what the standard module is in the c#
> workbook-project (which class represents the standard module?).
>

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