View Single Post
 
Old 03-10-2021, 12:46 PM
AnBad AnBad is offline Windows 10 Office 2019
Novice
 
Join Date: Mar 2021
Posts: 5
AnBad is on a distinguished road
Default Hide Text in a document.

Hi,
I have a document with some simple word spreadsheets. I gave all of them a bookmark name so that I can hide and unhide the spreadsheets.

Everything works fine only some sheets got the value:

ActiveDocument.Bookmarks(MyRange.Bookmarks(x).Name ).Range.Font.Hidden = 9999999

It should -1 (hidden) or 0 (not hidden). But some have 9999999

I did some digging and realized that the spreadsheets with faulty 9999999 are showing at fonts/effects full filled marks everywhere from "Strikethrough" up to "Hidden" (not in this picture, they are all empty her cause I could find a pic online). That cant be, cause nothing is strikenthrough...

I cant find why. What is going on here?

I need this cause I want to create a list with all visible Bookmarks via VBA.

Thank you

Reply With Quote