Hi Paul,



I can't thank you enough!
I have never heard of the ghost feature before.

Some serious coding here,although it's way too advanced for me at the moment to understand, I can appreciate the complexity.

I have been trying to solve this problem for the past week unsuccessfully, so its really generous of you to solve this problem.

The code looks smashing.

In case I need to check the hidden columns I change the array numbers and the hidden set becomes visible - I tried that and so far it seems OK.

I hope you don't mind me asking - am I able to change the font size in the main Visible columns? Its a size 12 at the moment - If I can make the font bigger it would be easy on the eyes. If not no worries. I can do it manually.

For hidden text - the font size you have coded below - i can easily change that - thank you.


With Sty
With .Font

.Hidden = bHidden
.Size = 12


Again I thank you very much for your generous time and coding skills in helping me!


J

There isn't one - "TblGhost" is the name of a Style the macro creates.
You can make the font whatever size you want, just by changing the 12 in:
.Size = 12

For an existing document that's already had the macro run on it, simply modify the font size for the "TblTxt" Style. That's the power of using Styles - change the Style definition and everything based on that Style updates.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]