#1
|
|||
|
|||
Checkbox
Hi all! Is it possible to use track changes to show the initials of the person who just ticked a checkbox? |
#2
|
||||
|
||||
Assuming you're using a content control checkbox, yes - Track Changes records who last updated it.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Ok thanks! Do you know if it's possible to get the initials of the person in the checkbox instead of the tick?
|
#4
|
||||
|
||||
What you get really for tracked change depends on what's in the username field under File|Options|General.
Checkboxes display check characters, not text. A macro could be used to insert the initials after the checkbox (e.g. in a text content control). Besides which, simply recording the initials isn't especially helpful if someone unchecks a checkbox someone else had checked - without the checkbox being present, you'd never know what the final check state was.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
||||
|
||||
You could use an on exit macro on Content Controls to record the user who last visited the checkbox. For instance the macro could write the username to the Tag property or somewhere else in the document.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#6
|
|||
|
|||
Thanks! I'll definitely look into that
|
#7
|
||||
|
||||
If you use a checkbox content control titled 'Chk1', for example, and a corresponding text content control titled 'Chk1Inits', you could use a ContentControlOnExit macro like:
Code:
Private Sub Document_ContentControlOnExit(ByVal CCtrl As ContentControl, Cancel As Boolean) Application.ScreenUpdating = False With CCtrl If .Type = wdContentControlCheckBox Then With ActiveDocument.SelectContentControlsByTitle(.Title & "Inits")(1) .LockContents = False .Range.Text = Application.UserInitials .LockContents = True End With End If End With Application.ScreenUpdating = True End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
check box, initials |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
One Content Control Checkbox checks another Content Control Checkbox | DEsh | Word VBA | 2 | 10-06-2017 08:23 PM |
Checkbox in Userform | lukael | Excel Programming | 5 | 02-18-2014 05:20 AM |
checkbox issue | Deepa Shrestha | Word | 3 | 07-24-2013 12:05 PM |
macro on checkbox | macrohelp | Word VBA | 0 | 03-06-2009 03:33 PM |
resizing a checkbox?? | aceensor | Excel | 0 | 05-10-2006 01:44 PM |