Code Module to Add In
 

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

Code Module to Add In
 

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

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

Code Module to Add In
 

Hi Matt

Same site:
http://www.j-walk.com/ss/excel/tips/tip90.htm
also
http://www.mcgimpsey.com/excel/easiertimeentry1.html

HTH. Best wishes Harald

"Matt Jensen" skrev i melding
...
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

Code Module to Add In
 

Cool thanks Harald
Didn't see that J Walk one.
Matt

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

Same site:
http://www.j-walk.com/ss/excel/tips/tip90.htm
also
http://www.mcgimpsey.com/excel/easiertimeentry1.html

HTH. Best wishes Harald

"Matt Jensen" skrev i melding
...
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