View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Automating marrying PERSONAL.XLS and Excel11.xlb?

Why not create the buttons in the open event and ensure they are deleted
when it unloads (particularly if temporarily on someone else's system). IOW,
same way it would be done with an addin.

Regards,
Peter T


"StargateFan" wrote in message
...
Whenever I go to a new contract and set up, I have to then manually
assign all my macros to my custom buttons on the Excel11.xlb. I was
wondering if there was a quicker, easier way to do this
programatically, somehow?

Thanks! :oD