why doesn't macro record text color, or patterns?

C

Cat

In the new version of excel, when I record a macro to change font colors,
cell borders, border fills, etc, everything records correctly. But then when
I use the macro, it doesn't change the formatting like I recorded. I used to
do this in the old version of excel with no issues. Can anyone help?

Thanks,
 
G

Gord Dibben

Was upgrade to Office 2007 the only change on your computer?

Can you see the color changes in PrintPreview?

If so.....................

Check this out................

http://support.microsoft.com/default.aspx?kbid=833258

The fill color, the fill pattern, or the line color of a WordArt or
AutoShape object in an Office document does not change

As directed, change the High Contrast setting in Windows OS


Gord Dibben MS Excel MVP
 

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

Conditional Formatting macro: simple, but doesn't work 6
Remove Hyperlinks Without Changing background shading 14
Macro Recorder Doesn't Record Anything 1
Insert Border 2
Excel 2007 Chart Colors 3
Filling a macro button with colour ( color) 4
Error LineStyle 2
REQ Help with simple Excel macro 5

Top