Override a built-in command with a macro

R

Robert Schwenn

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
 
J

Jim Thomlinson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
Need Help with Macro Security 1
Set as Default Template not working 0
Override a built-in command with a macro 8
Embedded Excel into Word with Tables 0
Making a macro only work on certain files 2
Change a great number of words in word files, with a macro as short as possible. 5
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top