View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Matt Jensen Matt Jensen is offline
external usenet poster
 
Posts: 113
Default Code Module to Add In

Harald
Do you know of any example of creating a toolbar on open similar like
J-Walks one but for a toolbar instead of a menu?
Thanks
Matt

"Harald Staff" wrote in message
...
Hi Wayne

To make an addin, see
http://www.erlandsendata.no/english/...aaddinsgeneral
http://www.erlandsendata.no/english/...baaddinexcel97

Before that you need to code it so that it creates a menu or a toolbar

when
opened. Here's a good one:
http://j-walk.com/ss/excel/tips/tip53.htm


HTH. Best wishes Harald

"wayne" skrev i melding
...
Can a code module be "transformed" into an addin so that
when any instance of excel is opened a toolbar button
appears and when selected activates the code module?

Any ideas on how this is done????

thanks

Wayne