Trigger shape custom action from VBA

Started by gtakla, November 13, 2016, 07:50:40 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

gtakla

Hi,

I need to trigger an action row in a shape from VBA.
Thanks
gt

Yacine

Interesting. The other way around.
Could you think of modifying the action row by adding a "dependson" predicate?
This way you could modify a cell that is "depended on", this will trigger the formula in the action row.
Yacine

gtakla

Thanks. I figure it out and it is  the same solution you mentioned.  :D
gt

JohnGoldsmith

Another way would be to invoke the Trigger method on the cell you're after.  For example, something like:


myShape.CellsU("myActionCellName").Trigger


best regards


John
John Goldsmith - Visio MVP
http://visualsignals.typepad.co.uk/

Browser ID: smf (is_webkit)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 191 (show)
Files included: 34 - 1321KB. (show)
Memory used: 1130KB.
Tokens: post-login.
Cache hits: 12: 0.00188s for 26,583 bytes (show)
Cache misses: 1: (show)
Queries used: 15.

[Show Queries]