Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba: setting font color to entire sheet
Hello, What i've typed doesnt work, and i'm wondering if i could have advic on how to set the entire worksheet to default font color. right now i have Worksheets(1).font.colorindex=xlautomatic what is it supposed to be??? thanks guys. ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting font color to entire sheet
Try the following to set the ColorIndex of all cells to
xlColorIndexAutomatic ActiveSheet.Cells.Font.ColorIndex = xlColorIndexAutomatic -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "chick-racer" wrote in message ... Hello, What i've typed doesnt work, and i'm wondering if i could have advice on how to set the entire worksheet to default font color. right now i have Worksheets(1).font.colorindex=xlautomatic what is it supposed to be??? thanks guys.. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting font color to entire sheet
try using the sheet name
Sheets("Sheet4").Cells.Font.ColorIndex = 0 -- Don Guillett SalesAid Software "chick-racer" wrote in message ... Hello, What i've typed doesnt work, and i'm wondering if i could have advice on how to set the entire worksheet to default font color. right now i have Worksheets(1).font.colorindex=xlautomatic what is it supposed to be??? thanks guys.. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba: setting font color to entire sheet
THANK YOU!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format for font color using font color | Excel Worksheet Functions | |||
Why copying the sheet to diff file changes font color? | Excel Worksheet Functions | |||
How do I change the font color of each sheet title? | New Users to Excel | |||
Change font color across entire row | Excel Discussion (Misc queries) | |||
How do I change the font color of my sheet tabs? | Excel Discussion (Misc queries) |