Solved

Action Tags section in shapesheet - vba to set Disabled = True

Posted on 2014-04-11
2
570 Views
Last Modified: 2014-04-12
I seek to disable Smart Tags.row1 in Section containing Action Tags.
I cant formulate CellsSRC correctly.

Thanks
Kelvin
0
Comment
Question by:Kelvin4
2 Comments
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
ID: 39996065
http://msdn.microsoft.com/en-us/library/office/ff768125(v=office.14).aspx should tell you what you need.

shp.CellsSRC(visSectionSmartTag, nnn, visSmartTagDisabled).Formula = True
e.g., nnn=0 will set the value in the first Smart Tag row
or
shp.Cells("SmartTags.<<row name>>.Disabled").Formula = True
0
 

Author Closing Comment

by:Kelvin4
ID: 39996243
Scott-
Yes!!
Thanks,
-Kelvin
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent Visio zone question asked how to use the data in an Excel file to create a Visio Gantt chart -- and then to dynamically update the Gantt chart. The good news is that the Viso Gantt Chart wizard can be automated. The bad news is that the…
The ability to add structure to Visio diagrams using containers, lists and callouts is one of my favorite features in Visio 2010. In this article we’ll examine containers. We’ll explore lists (http://www.experts-exchange.com/Microsoft/Applications/M…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question