Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 04-25-2017, 09:31 AM
Irimi-Ai Irimi-Ai is offline how to make sections hidden/appear based on selection in Cont. Ctrl. Drop-down list Windows 7 32bit how to make sections hidden/appear based on selection in Cont. Ctrl. Drop-down list Office 2013
Novice
how to make sections hidden/appear based on selection in Cont. Ctrl. Drop-down list
 
Join Date: Apr 2017
Posts: 3
Irimi-Ai is on a distinguished road
Thumbs up

Quote:
Originally Posted by macropod View Post
...the only workable approach would be to use bookmarked ranges for where the conditional content is to go and to store that content, with all its formatting in an external document from where it can be copied into the 'main' document - use VBA code tied to the content control 'on exit' event. It also means having two documents and, if your users can't be guaranteed to have access to a common folder in which that document is stored, both would need to be kept in the same folder.
That was it! I set up a reference ("master") file on a shared network drive (actually in a hidden folder with file properties set as "read-only" so less chance of it being tampered) and bookmarked the different sections/content. Then, in the separate template I used InsertFileRange to insert certain bookmarked ranges from the reference file depending on the selection in the Content Control drop-down. That was exactly what I needed...thanks for the guidance!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to make sections hidden/appear based on selection in Cont. Ctrl. Drop-down list Word VBA - "Page left Blank" between Sections to make all Sections start on even page Cov_ATC Word VBA 10 11-28-2021 03:41 PM
How to link a drop down list to certain sections/headings? Johnheng82 Word 0 02-22-2017 04:36 PM
Hide/Unhide Text Based on Drop Down Selection gw1500se Word 3 02-19-2015 12:17 PM
how to make sections hidden/appear based on selection in Cont. Ctrl. Drop-down list Dynamically changing drop-down list based on selection? (Word Form) laurarem Word 1 02-21-2013 10:17 PM
how to make sections hidden/appear based on selection in Cont. Ctrl. Drop-down list Change cell color when selection is made from a drop down list fedcco Excel 12 08-28-2012 10:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft