Macro

T

Tony O'Hara

Hi all,
I have a macro inside my 'normal.dot' file which runs
on a 'File/New' operation. I was wondering if anyone knew
a method of doing this in Excel

thanks in advance!

Tony
 
D

Dave Peterson

Depends on what you want to do.

The most generic answer would be to create an application event that looks for
new workbooks and executes a macro when that happens.

But this is pretty much overkill in most applications (my opinion only).

You may want to read some more about application events at Chip Pearson's site:
http://www.cpearson.com/excel/AppEvent.htm

Chip also has some nice notes about workbook/worksheet events at:
http://www.cpearson.com/excel/events.htm



What do you really want to happen?
 
Top