Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-26-2020, 03:55 PM
Guessed's Avatar
Guessed Guessed is offline VBA to conditionally hide text by language/structure? Windows 10 VBA to conditionally hide text by language/structure? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default


Are you saying the macro can't use styles or language settings to identify the language that is used? If so, how do you propose the macro identifies the chosen language?

I think we would need to see a sample document to understand what needs to be done.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #2  
Old 08-26-2020, 11:40 PM
tyxanu tyxanu is offline VBA to conditionally hide text by language/structure? Windows 8 VBA to conditionally hide text by language/structure? Office 2013
Novice
VBA to conditionally hide text by language/structure?
 
Join Date: Aug 2020
Posts: 13
tyxanu is on a distinguished road
Default

Just take a look here: xz — ImgBB

Styles are the same on both columns.

In 90% of the cases even the proofing for both columns is set similar(let's say ENGLISH(US) for both, although we technically have english on the left and german on the right).

I have to manually go all the way down selecting one or more paragraphs at a time(depending on how the file is structured) and hide one language(ALT+Z, my personal macro for fast hiding), repeatedly, thousands of times
Reply With Quote
  #3  
Old 08-26-2020, 11:53 PM
tyxanu tyxanu is offline VBA to conditionally hide text by language/structure? Windows 8 VBA to conditionally hide text by language/structure? Office 2013
Novice
VBA to conditionally hide text by language/structure?
 
Join Date: Aug 2020
Posts: 13
tyxanu is on a distinguished road
Default

So in this case:

-do I have at least a solution to automatically repair the proofing so I can afterwards use find&replace or a macro?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to text heading1 text heading1 text? How to collapse or hide text in the middle of a line. TImer Word 7 08-10-2020 12:52 AM
VBA to conditionally hide text by language/structure? Conditionally Color Formatting Text selected from a dropdown list in Word 2010 pgammag Word 9 08-20-2019 04:17 PM
Conditionally hide parts of a document elaineAda Word VBA 0 04-01-2019 10:00 PM
Insert a text conditionally deboer Word 1 05-04-2014 03:35 PM
Header must toggle text & color + show count of conditionally formatted cells below Franktoon Excel 3 02-18-2014 02:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:04 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