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?

where to place undo-function in vsto-projects?
 

Hi Cribe,

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


--
Regards,
Norman



"cribe" wrote in message
...
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?

where to place undo-function in vsto-projects?
 

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

where to place undo-function in vsto-projects?
 

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" wrote in message
...
the problem is, i don't know where/what the standard module is in the c#
workbook-project (which class represents the standard module?).

where to place undo-function in vsto-projects?
 

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