Just to add:

commandbars("Custom1").Controls("MyControl").OnAct ion =
"MyWorkbook.xls!MyMacro"

--
Regards,
Tom Ogilvy

"VBA Fun" .(donotspam) wrote in message
...
When a file containing a macro is saved using 'save as' under a new name
the
toolbar buttons are modified...the assign macro setting is changed to the
new
name.

Is there a way to programatically change the assignment? If not, do you
have any suggestions on how to distribute a VBA application, where the
functions are made easily accessible through a custom toolbar, without the
risk of the assignment getting modified?

Thanks in advance,



--
VBA Fun