title: Excel 2007 - Catch open command bar button event
body: <p>Prior to Excel 2007, we used to catch the open file event in Excel using vba so that we could show our own open dialog that knew how to find client folders.  In Excel 2007 this no longer works, does anyone have any ideas on how it works now></p>
  
  <p>The basic premise before was create a class with a commandbar button and a related event and then set that commandBarButton when the app opened and it would catch it, but now it does not.  Is there another way now?</p>
  
  <p>Public WithEvents cmdBold          As Office.CommandBarButton
  Private Sub cmdBold_Click (ByVal Ctrl As Office.CommandBarButton, _
                             CancelDefault As Boolean)
     ' Insert code you want to run in response to this event.
  End Sub</p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/aa189726(office.10).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/aa189726(office.10).aspx</a></p>