+ Reply to Thread
Results 1 to 7 of 7

TOP secret text proportional fonts

  1. #1
    Registered User
    Join Date
    03-11-2019
    Location
    Slovenija
    MS-Off Ver
    365
    Posts
    12

    TOP secret text proportional fonts

    Hi,

    part of document is top secret. Needs to be blacked out, but before that characters replaced with something like XXXXXX. The only issue is that text width in each line must be the same after replacement and fonts used are unfortunately proportional.

    Any hints or ideas which way to look for a solution?

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2304
    Posts
    39,577

    Re: TOP secret text proportional fonts

    I think you have a problem to do this neatly, if monospace fonts are not used.
    Glenn



  3. #3
    Registered User
    Join Date
    03-11-2019
    Location
    Slovenija
    MS-Off Ver
    365
    Posts
    12

    Re: TOP secret text proportional fonts

    I know Can use VBA and I am brainstorming any idea which direction to go to...

    Just came up with an idea that might work. Can read string in each line including spaces, randomly shuffle and rewrite same string. Don't know how good is this for in terms of cryptography but for my needs it might work.
    Idea no 1 If anyone has any other let me know please...

  4. #4
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,723

    Re: TOP secret text proportional fonts

    You could use a macro to calculate the width of each redaction word, then replace that word with
    • an inlineshape of the same width; or
    • a string of characters (e.g. X) and adjust the character spacing to achieve the same width.
    Last edited by macropod; 03-10-2021 at 10:39 PM.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  5. #5
    Registered User
    Join Date
    09-01-2021
    Location
    Canada
    MS-Off Ver
    10
    Posts
    2

    Re: TOP secret text proportional fonts

    Maybe I'm being silly, but can't it be painted over for a while? I just have a document where one part should not be seen by colleagues. So I just painted that part black.

  6. #6
    Registered User
    Join Date
    03-11-2019
    Location
    Slovenija
    MS-Off Ver
    365
    Posts
    12

    Re: TOP secret text proportional fonts

    Quote Originally Posted by Ontoris View Post
    Maybe I'm being silly, but can't it be painted over for a while? I just have a document where one part should not be seen by colleagues. So I just painted that part black.

    Unfortunately not enough. Text is seriously top secret and goal is to prevent copy paste from PDF if user is not careful enough to prevent this in pdf file.

  7. #7
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,723

    Re: TOP secret text proportional fonts

    The following macro redacts all yellow-highlighted content in a document, replacing the highlighted content with essentially empty black-highlighted blocks having the same print width.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert to Bold Fonts in a concatenated text
    By lts_ram in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-20-2016, 05:31 AM
  2. Secret Santa
    By andypandy1969 in forum Excel General
    Replies: 2
    Last Post: 11-10-2015, 06:57 PM
  3. copy only fonts(text color) from one string of text to another string of text
    By JMJ123 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-06-2013, 04:22 AM
  4. Need secret fromula
    By jbartagoodeair in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2009, 09:15 AM
  5. Output text in different fonts
    By koticphreak in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-15-2008, 05:21 PM
  6. [SOLVED] Symbol and Tahoma fonts in same text box?
    By Abraham.Olson@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2006, 01:10 AM
  7. [SOLVED] How can I lengthen the drop down Fonts list to show more fonts at
    By Moser D in forum Excel General
    Replies: 1
    Last Post: 02-05-2006, 11:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1