View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Run code when ANY file opens

http://www.cpearson.com/excel/appevent.htm

so you would need to start application level events by using an addin in
Excel that is loaded when excel starts.

--
Regards,
Tom Ogilvy




"Shimmess" wrote:

I want to run some VBA code on a PC whenever ANY workbook is opened in excel.
It can not only be when excel opens, it need to be even if a new file is
oened once excel is already running. Any suggestions?