View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Hanlde "New Workbook" Task Pane Events

You are looking for an application level event. Check out this link...

http://www.cpearson.com/excel/AppEvent.htm
--
HTH...

Jim Thomlinson


"Patrick Hampton" wrote:

We have created a VSTO addin for Excel 2003 and have written code to manage
creation of new workbooks. However, we have been unable to find a control or
an event that we can hook to that would allow us to run our code when the
user creates a new workbook from the "New Workbook" task pane. Can anyone
tell me how to accomplish this?