Override a built-in command with a macro
 

Hi,
I'd like to see a macro running when invoking a built-in command. I.e. when
choosing "File - New" my own macro should run.

I already asked this question on another news group and got the answer, that in
Word, I only have to give my macro the same name as the desired Word command.

This works great - in Word. But is there a similar way in Excel? If yes, how can
I get a list of these commands?


Robert

Override a built-in command with a macro
 

Word and XL are 2 very different things. In Word you are dealing with
modifications to the Normal.dot which is the starting point of all documents.
XL does not have the same structure. To do what you want will require
creating an addin. Within the addin you need to create an object to listen
for events that the XL application is firing.

Here are a couple of links to get you started...
http://www.cpearson.com/excel/AppEvent.aspx
http://www.cpearson.com/excel/CreateAddIn.aspx
--
HTH...

Jim Thomlinson


"Robert Schwenn" wrote:

Hi,
I'd like to see a macro running when invoking a built-in command. I.e. when
choosing "File - New" my own macro should run.

I already asked this question on another news group and got the answer, that in
Word, I only have to give my macro the same name as the desired Word command.

This works great - in Word. But is there a similar way in Excel? If yes, how can
I get a list of these commands?


Robert