Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2014-04-11
2
Medium Priority
?
620 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 31

Accepted Solution

by:
Scott Helmers earned 2000 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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

David Parker’s latest book, Microsoft Visio 2010: Business Process Diagramming and Validation, will give you the tools to turn flowcharts and other business diagrams into valuable, data-driven corporate assets. Armed with the knowledge you’ll gain f…
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 lists. We’ll explore containers and callouts in separate articles. Prior to reading th…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

926 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