View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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