Consulting

Results 1 to 2 of 2

Thread: Save As event not firing in Office 2007

  1. #1
    VBAX Newbie
    Joined
    Jun 2007
    Posts
    1
    Location

    Save As event not firing in Office 2007

    I wrote an event for Save As menu , it works fine for Office 2003, but its not working for Office 2007 (1 line of code below)

    If evtFileSaveAs Is Nothing Then Set evtFileSaveAs = 'Application.CommandBars("Menu Bar").FindControl(, 748, , True, True)

    I am expecting doubt like Save As Menu Id is not 748.

    Is there any solution for this?

    Thanks in advance and help appriciated.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    It is not a commandbar in 2007, it is on the ribbon, and you can't intercept as you previously could.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •