control an standard Excel macro (NL / XL / 2003)

Topic

New Reply

Hello all,

I want to control some of the standard Excel macros.
e.g. If a user selects the option ‘Insert Row’ from the menu, I wouldt like to start a controlmacro first before the Insert Row macro of Excel starts, or in some situations to prevent the Excel macro from starting.
(I hope I’m clear enough)

Thanks in advance foor your reaction.
Patrick Schouten
The Netherlands

Reply | Quote

Replies

Unlike Word, Excel has no way to intercept the built-in actions, and there is no “insert row” event that you can handle. See the thread starting at post 715,832 for some suggestions.

Reply | Quote

Thanks for the reply,
I will solve it an other way.

Reply | Quote

You can create a class module that intercepts a click on a specific commandbar control.
See this article on how that works (includes a download): http://www.jkp-ads.com/Articles/CatchPaste.asp%5B/url%5D

Reply | Quote