View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VBA Fun VBA Fun is offline
external usenet poster
 
Posts: 5
Default Assigning Macros to Toolbar buttons

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