Assigning Macros to Toolbar buttons
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
|