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"