Changing font color on all exposed and hidden columns

L

Lucas Soler

I want to change the font color to black for all exposed and hidden columns
in the project. The code below only changes the color for all exposed
columns. Any ideas?

SelectSheet
Font Bold:=False, Underline:=False, Color:=0

Thanks!
 
J

John

Lucas Soler said:
I want to change the font color to black for all exposed and hidden columns
in the project. The code below only changes the color for all exposed
columns. Any ideas?

SelectSheet
Font Bold:=False, Underline:=False, Color:=0

Thanks!
Click to expand...

Lucas,
That's because the Font property only applies to active tasks. One of
the obvious disadvantages of that is that font characteristics can not
be applied using background processing. Bummer!

John
Project MVP
 
L

Lucas Soler

John,
Interestingly, if I manually select a single row and change the font color,
it applies to all columns (hidden and exposed). Doesn't work when I select
multiple rows.

Cheers.
 
J

John

Lucas Soler said:
John,
Interestingly, if I manually select a single row and change the font color,
it applies to all columns (hidden and exposed). Doesn't work when I select
multiple rows.

Cheers.
Click to expand...

Lucas,
I didn't read your post carefully. Although what I said is still true, I
didn't pick up on the issue of shown versus hidden columns. Just for
reference I did a little test of my own. Using VBA I can change the font
characteristics of all fields in a column (any number of rows) even if
they are not shown. The trick is to set up the view table so the fields
are present but have their column width set to zero. Those fields will
not appear on the view, but you can still change their font
characteristics. Try it with a simple two row project.

Sub FontChartest()
SelectRow row:=1, rowrelative:=False, Height:=2
Font Color:=pjRed
End Sub

John
Project MVP
 
J

John

Lucas Soler said:
Very helpful. Thanks, and have a positive weekend!
Click to expand...

Lucan,
A positive weekend, Hmmmmmm, I wonder what that is exactly. Nonetheless,
you're welcome.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
How to modify and updte specific styles for specific paragraphs across the document 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Macro Code for bringing up Save As dialog box and changing file Type 0
How do i test for a font color in Task cell ? 5
creating new template - change default heading style 7
Try to modify a row, but found out Task ID and row number are not 7
Font color button 10

Top