PDA

View Full Version : Save As event not firing in Office 2007



kvreddy
06-04-2007, 07:51 PM
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.

Bob Phillips
06-05-2007, 02:54 PM
It is not a commandbar in 2007, it is on the ribbon, and you can't intercept as you previously could.