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

  • Thread starter Thread starter Cat
  • Start date Start date
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,
 
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
Syntax of Commands Created by Macro Recording 5
GridLines Inadvertantly Goes Away with Macro 3
Cell pattern-style and color in Excel 2007 6
Cell pattern-style and color in Excel 2007 6
Excel Macro to automatically go to the right of the last colored cell 0
Filling a macro button with colour ( color) 4

Back
Top