View Single Post
 
Old 03-04-2015, 07:32 AM
ugcheleuce ugcheleuce is offline Windows 7 64bit Office 2003
Novice
 
Join Date: Mar 2014
Location: Netherlands
Posts: 24
ugcheleuce is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
Provided the green colour is that shown in the sample, the following will mark the text in those green cells as hidden/unhidden.
Thanks, this really helps.

The grey cell in my sample file doesn't show an RGB value when I click in it and make as if I want to change the shade colour -- does that mean that that cell is not shaded but that it's greyish background colour is due to something else?

==
Added: After a bit of tinkering I figure out how to mark that cell's text as hidden, too:
Code:
If oCell.Shading.Texture = wdTexture10Percent Then
but... some other cells in my document (see sample2.doc) are a darker grey, and they don't respond to the updated macro, which leads me to suspect that they are shaded using an even diffent method.

Do you know what method I must use to hide the text in the darker grey cells on the second page of the sample2.doc file?

==
Added2: Oh, I figured it out -- the darker grey is 191, 191, 191.

But my woes continued. Elsewhere in the file (sample not attached) is a cell whose greyness is indicated by the borders&shading dialog as "Grey -15%". Sigh... but then I found out that that was just MS Word's say of saying 217, 217, 217.

Samuel
Attached Files
File Type: doc sample2.doc (105.0 KB, 9 views)
Reply With Quote