Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / October 2006

Tip: Looking for answers? Try searching our database.

Need to update format of Macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
scook@sdgdocs.com - 14 Sep 2006 19:53 GMT
If anyone can assist me with the following problem I would greatly
appreciate it!

I am using a Word Template which contains various tables. One column in
one of the tables contains a check box, which is associated with a
Marco. The function of this Macro is to highlight the row when the
check box is checked. Here is the Macro that I am currently using:

Sub REDhighlightwhenchecked()
'
' REDhighlightwhenchecked Macro
' Macro created 9/14/2006 by Shannon Cook
'
Dim ffname As String
ffname = Selection.FormFields(1).Name
With ActiveDocument
   .Unprotect
   If .FormFields(ffname).CheckBox.Value = True Then
       .Bookmarks(ffname).Range.Rows(1).Shading.BackgroundPatternColor
_
            = wdColorRed
   Else
       .Bookmarks(ffname).Range.Rows(1).Shading.BackgroundPatternColor
_
            = wdColorAutomatic
   End If
   .Protect wdAllowOnlyFormFields, NoReset
End With

End Sub

Here is the current situation: I am in the process of altering the
format of the template. Instead of having only one check box in the
row, I will now have 6 check boxes in a single row. Each check box is
associated with a different color. What I have found is that I need to
alter the existing macro to have the check boxes be mutually exclusive,
i.e. Each row can only have one check box checked at a time.

Help!
thebonesers
Cindy M. - 15 Sep 2006 10:30 GMT
Replied to same question in the word.docmanagement
newsgroup.

   Cindy Meister
shanbones@yahoo.com - 15 Sep 2006 14:31 GMT
> Replied to same question in the word.docmanagement
> newsgroup.
>
>     Cindy Meister

Thank you Cindy! I have been looking at the website you suggested. Can
you please let me know the name of the article?

Thank you,
SCook
Cindy M. - 16 Sep 2006 15:34 GMT
> Thank you Cindy! I have been looking at the website you suggested. Can
> you please let me know the name of the article?

Please reply to the other message thread. I see some 1000 messages per
day and have no idea what I suggested to you in the other thread...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)
Russ - 09 Oct 2006 02:38 GMT
Scook,
I went to the site Cindy mentioned and did a site search using their
searchbar for "mutually exclusive checkboxes" and this was the first result
in the list:
http://word.mvps.org/faqs/tblsfldsfms/ExclusiveFmFldChbxs.htm

>> Replied to same question in the word.docmanagement
>> newsgroup.
[quoted text clipped - 6 lines]
> Thank you,
> SCook

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.