View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Starting a Macro when Command is Executed?

You can trap events and fire your macro from there. For instance, there is a
BeforePrint event. See http://www.cpearson.com/excel/events.htm, it says
Excel97 but it is still valid.

--
HTH

Bob Phillips

"Losse" wrote in
message ...

Is there anyway for me to have a macro run automatically whenever an
action is done on Excel? For example, could I set up a macro that saves
the file to automatically run whenever I print?


--
Losse
------------------------------------------------------------------------
Losse's Profile:

http://www.excelforum.com/member.php...o&userid=24813
View this thread: http://www.excelforum.com/showthread...hreadid=386133