Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code module? | Excel Worksheet Functions | |||
Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
code to add module | Excel Programming |