Thread: [Solved] Bookmark content controls
View Single Post
 
Old 06-12-2016, 04:19 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,365
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Ah, I hadn't seen silverspr's last post (#16) when I replied - the forum software only advises of the first reply after one's last visit and, when I replied, didn't see that the thread now has a second page. I agree that formulae won't work for cells containing text - they can be used for retrieving the numeric content of cells containing alpha-numeric content, but not the text. Accordingly, the only viable option will be to either:
• switch from content controls to formfields and use field coding for the calculations; or
• drive the whole process via a ContentControlOnExit macro, with or without the mapping you suggested.

silverspr: If you store the macro in the document's template and store the template in a trusted location, there'll be no need for your users to enable them each time one of these documents is created/opened.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote