ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Menu Item (https://www.excelbanter.com/excel-programming/406902-menu-item.html)

Greg B[_3_]

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



JP[_4_]

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



Greg B[_3_]

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




Greg B[_3_]

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 -




JP[_4_]

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



All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com