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