Identify which Button of which User defined CommandBar was clicked

[MY-Rudy]

Hi, I am using an Excel File which was generated under Office97 and is running with Office10 without problems. Every newer version Office11 and later the file is not working.

Basic Problem: the file contains two user defined CommandBars "Calculation Toolbar" and "Edit Toolbar". The Application.Caller function is used to identify the button and the name of the toolbar.

BtnIndex = Application.Caller(1) 'returns button number on toolbar
ToolBar = Application.Caller(2) 'returns name of the toolbar

The new office version returns the correct number for the BtnIndex but for the ToolBar variable I only receive a number as string. I could not find a correlation between this number Application.Caller(2) deliveres and the needed name of the calling CommandBar.

Is there another function I can use to identify the name of the toolbar where the button is located is clicked?

Thanks in advance.

Rudy

 

[MY-Rudy]

...ok, I found the solution:

BtnIndex = Application.CommandBars.ActionControl.Index
ToolBar = Application.CommandBars.ActionControl.Parent.Name

so instead of using the Application.Caller function the ActionControl can do.

Perhaps this is useful for people with a similiar problem.

Thanks.

Rudy.