Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
the problem is, i don't know where/what the standard module is in the c#
workbook-project (which class represents the standard module?). |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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?). |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
so you think it's not even possible to call a c# function?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel's Undo Function | Excel Worksheet Functions | |||
Function with VSTO ? | Excel Programming | |||
Why is my undo function in Excel only can undo the last 1 or 2 ch. | Excel Worksheet Functions | |||
How to become a better programmer, post college. More projects or less projects. | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |