| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
why doesn't macro record text color, or patterns?
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
why doesn't macro record text color, or patterns?
Always nice to post your code for comments
-- Don Guillett Microsoft MVP Excel SalesAid Software "Cat" wrote in message ... 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, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
why doesn't macro record text color, or patterns?
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 On Tue, 22 Sep 2009 12:37:02 -0700, Cat wrote: 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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I record a macro on a cell that has text but not a text box | Excel Worksheet Functions | |||
| Error Messages: 'Text String is Too Long...'; 'Can't Record Macro' | Excel Programming | |||
| Can I vary the shade or intensity of the color patterns? | Excel Discussion (Misc queries) | |||
| Make text color match cell color with macro? | Excel Discussion (Misc queries) | |||
| Record Macro - Record custom user actions | Excel Programming | |||
Linear Mode
