Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Item
Hi all,
I am wondering how to get the toolbar item get From &Scanner or Camera. to show using vba. I mean the insert - picture - From & Scanner or Camera Thanks Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Item
Check out http://tinyurl.com/35jbhg
You can make a list of all the commandbr controls. HTH, JP On Feb 28, 9:04*pm, "Greg B" <browgregory(NO wrote: Hi all, I am wondering how to get the toolbar item get From &Scanner or Camera. to show using vba. I mean the insert - picture - From & Scanner or Camera Thanks Greg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Item
Thanks for that, just how do I use it?
Thanks Greg "JP" wrote in message ... Check out http://tinyurl.com/35jbhg You can make a list of all the commandbr controls. HTH, JP On Feb 28, 9:04 pm, "Greg B" <browgregory(NO wrote: Hi all, I am wondering how to get the toolbar item get From &Scanner or Camera. to show using vba. I mean the insert - picture - From & Scanner or Camera Thanks Greg |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Item
Thanks for that, I never noticed the extra menu item.
Greg "JP" wrote in message ... Download CommandBar Tools from the link on that page. Unzip the file and extract the XLA file to your destination of choice. Double click on the file and make sure you enable macros if prompted. It adds a menu to the toolbar on top called "EDC Tools" you would click on that and select "List all commandbar controls". Then you can simply search for the control you are trying to automate. HTH, JP On Feb 28, 10:25 pm, "Greg B" <browgregory(NO wrote: Thanks for that, just how do I use it? Thanks Greg"JP" wrote in message ... Check outhttp://tinyurl.com/35jbhg You can make a list of all the commandbr controls. HTH, JP On Feb 28, 9:04 pm, "Greg B" <browgregory(NO wrote: Hi all, I am wondering how to get the toolbar item get From &Scanner or Camera. to show using vba. I mean the insert - picture - From & Scanner or Camera Thanks Greg- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Item
You're welcome, post back the final code so others can learn as well.
Thx, JP On Mar 2, 6:54*pm, "Greg B" <browgregory(NO wrote: Thanks for that, I never noticed the extra menu item. Greg"JP" wrote in message ... Download CommandBar Tools from the link on that page. Unzip the file and extract the XLA file to your destination of choice. Double click on the file and make sure you enable macros if prompted. It adds a menu to the toolbar on top called "EDC Tools" you would click on that and select "List all commandbar controls". Then you can simply search for the control you are trying to automate. HTH, JP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add menu item to right-click menu | Excel Programming | |||
Adding Sub Menu Item to Current Custom Menu | Excel Programming | |||
Menu Item name | Excel Programming | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming |