I think you have confused Excel by having "mymacro" in two separate
workbooks.

Delete the "mymacro" from the workbook then save.

Close Excel then reopen with your saved workbook.

Where does the toolbar button point to?


Gord

On Tue, 7 Oct 2008 23:22:47 +0200, "thomas" <nomail wrote:

I tried

.OnAction = "'" & ThisWorkbook.Name & "'!mymacro"

and it's the same :

It's mymacro in the active workbook that runs and not the one in the xla
file project


"Gord Dibben" <gorddibbATshawDOTca a écrit dans le message de groupe de
discussion : ...
See Debra Dalgleish's site for code to create an add-in with code to add a
Toolbar.

http://www.contextures.on.ca/xlToolbar02.html

Note the .OnAction line using Thisworkbook as Ron pointed out.


Gord Dibben MS Excel MVP

On Tue, 7 Oct 2008 20:07:49 +0200, "thomas" <nomail wrote:

Unfortunately i tried it today at the office and it does not work

mymacro is in the xla file and the menu command makes it works

if i open an xls workbook containing a copy of mymacro and then the menu
command makes that copy work. If i deleted that copy, a message says it
does not find 'mymacro'


"Ron de Bruin" a écrit dans le message de groupe
de discussion : ...
Try this Thomas

.OnAction = ThisWorkbook.Name & "!mymacro"