#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 897
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 897
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add menu item to right-click menu [email protected] Excel Programming 1 July 15th 06 10:32 AM
Adding Sub Menu Item to Current Custom Menu Renato Excel Programming 2 December 19th 05 12:48 AM
Menu Item name Christopher Sequeira Excel Programming 4 June 13th 05 08:58 PM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM
Adding a menu item right click menu when clicking on a single. Andoni[_28_] Excel Programming 0 September 2nd 04 10:23 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"