Creating a worksheet ActiveX button via code seems different than one from Control Toolbox
Note this may be version specific; I'm on 2003. In 2003 View/Toolbar/Control Toolbox and drag command button to sheet to create a command button. Then in design mode, right click, and you see "properties" where you can, e.g. set an accelerator.
But if you use the code below (which is what macro recorder shows for what I just described, by the way) (and matchs Help example for Add method for OLEObjects), right clicking has no "properties", and the button is not as versatile - for example, I have been unable to set an accelerator. Can someone explain the difference? (BTW, browsing the watch window shows both are OLE type 2, but there are other property differences apparent from comparing in the watch window).
Chip, if you can read this, you're STILL making the world a better place with your immeasurably valuable gifts. Every week, you continue to help me (and untold numbers of others) tremendously. Practically no alternative outlets can match your effectiveness, even over the vast number of topics you demystify and empower usage of. You were, and still are, amazing.
Re: Creating a worksheet ActiveX button via code seems different than one from Control Too
This was responded to in another thread, reproduced here.
Thank you for the useful and on point response.
Originally Posted by xlnitwit
No, they aren't. It's the same control
Okay, you're right. I'd still like to know if anyone knows how to add "Properties" to right click since it does not appear on the generated button (the only meaningful difference I now see).
If you wanted to add an accelerator using the code in your other thread you should only need to add
LinkBack URL
About LinkBacks
Register To Reply
Originally Posted by xlnitwit
Bookmarks