Solved

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

Posted on 2014-04-11
2
548 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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 I’ll describe a mashup of containers and lists that meet a real-world need. Prior to reading this ar…
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now