Microsoft Project Member for 17 years 9 months Member for 17 years 9 months Submitted by Darren Kosa on Tue, 2008-12-02 07:42 Permalink RE: Colour lines Assaf, Visual Basic is beyond my capabilities unfortunately. I’m not even 100% sure you’ll be able to change the cell colour using VBA, but that is the only option if you’re using 2k3. Regards, Darren Member for 17 years 10 months Member for 17 years 10 months Submitted by assaf f on Tue, 2008-12-02 06:03 Permalink RE: Colour lines Can you tell me what is the command in VBA? Member for 17 years 9 months Member for 17 years 9 months Submitted by Darren Kosa on Tue, 2008-12-02 06:02 Permalink RE: Colour lines Hi Assaf, I don’t think it is possible to colour a cell in 2k3 without VBA. In 2k7 you can change background colours by right-clicking in the cell, choose font and then the background colour / pattern. Regards, Darren Log in or register to post comments
Member for 17 years 9 months Member for 17 years 9 months Submitted by Darren Kosa on Tue, 2008-12-02 07:42 Permalink RE: Colour lines Assaf, Visual Basic is beyond my capabilities unfortunately. I’m not even 100% sure you’ll be able to change the cell colour using VBA, but that is the only option if you’re using 2k3. Regards, Darren
Member for 17 years 10 months Member for 17 years 10 months Submitted by assaf f on Tue, 2008-12-02 06:03 Permalink RE: Colour lines Can you tell me what is the command in VBA?
Member for 17 years 9 months Member for 17 years 9 months Submitted by Darren Kosa on Tue, 2008-12-02 06:02 Permalink RE: Colour lines Hi Assaf, I don’t think it is possible to colour a cell in 2k3 without VBA. In 2k7 you can change background colours by right-clicking in the cell, choose font and then the background colour / pattern. Regards, Darren
Member for
17 years 9 monthsRE: Colour lines
Assaf,
Visual Basic is beyond my capabilities unfortunately.
I’m not even 100% sure you’ll be able to change the cell colour using VBA, but that is the only option if you’re using 2k3.
Regards,
Darren
Member for
17 years 10 monthsRE: Colour lines
Can you tell me what is the command in VBA?
Member for
17 years 9 monthsRE: Colour lines
Hi Assaf,
I don’t think it is possible to colour a cell in 2k3 without VBA. In 2k7 you can change background colours by right-clicking in the cell, choose font and then the background colour / pattern.
Regards,
Darren