Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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?).

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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?).



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default where to place undo-function in vsto-projects?

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel's Undo Function sp3cialist Excel Worksheet Functions 1 February 8th 06 07:01 PM
Function with VSTO ? [email protected] Excel Programming 1 August 29th 05 02:17 AM
Why is my undo function in Excel only can undo the last 1 or 2 ch. 1111111111111111111111111111111111111111 Excel Worksheet Functions 1 November 24th 04 11:13 AM
How to become a better programmer, post college. More projects or less projects. Matt Somers Excel Programming 1 February 12th 04 01:54 PM
User-Defined Function pre-empting Built-in Function? How to undo???? MarWun Excel Programming 1 August 6th 03 09:31 PM


All times are GMT +1. The time now is 12:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"