Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
I have an excel form, it contains 3 different colors in the worksheet
and I want to print all except the color yellow is this possible. I want to print the all the cells only don't print the color yellow. (print back and white) where yellow. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
There is no way to tell the printer to ignore the yellow. You would have to
insert code before the print command to change the yellow font to black, or to change the yellow interior to white. " wrote: I have an excel form, it contains 3 different colors in the worksheet and I want to print all except the color yellow is this possible. I want to print the all the cells only don't print the color yellow. (print back and white) where yellow. thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
On Oct 28, 4:53 pm, JLGWhiz wrote:
There is no way to tell the printer to ignore the yellow. You would have to insert code before the print command to change the yellow font to black, or to change the yellow interior to white. " wrote: I have an excel form, it contains 3 different colors in the worksheet and I want to print all except the color yellow is this possible. I want to print the all the cells only don't print the color yellow. (print back and white) where yellow. thanks- Hide quoted text - - Show quoted text - Could you help me with the code, I would like to change the yellow interior to white. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
On Oct 29, 5:05 pm, wrote:
On Oct 28, 4:53 pm, JLGWhiz wrote: There is no way to tell the printer to ignore the yellow. You would have to insert code before the print command to change the yellow font to black, or to change the yellow interior to white. " wrote: I have an excel form, it contains 3 different colors in the worksheet and I want to print all except the color yellow is this possible. I want to print the all the cells only don't print the color yellow. (print back and white) where yellow. thanks- Hide quoted text - - Show quoted text - Could you help me with the code, I would like to change the yellow interior to white. Thanks. Maybe this can help you Sub Macro5() ' ' Macro5 Macro ' Macro recorded 29/10/2007 ' ' Change selected cells Colour to No fill Range("A1:M1").Select Selection.Interior.ColorIndex = xlNone 'Insert your print macro ' Change Selected cells back to yellow colour Range("A1:L1").Select With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With Range("A2").Select End Sub |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
On Oct 29, 2:51 am, pano wrote:
On Oct 29, 5:05 pm, wrote: On Oct 28, 4:53 pm, JLGWhiz wrote: There is no way to tell the printer to ignore the yellow. You would have to insert code before the print command to change the yellow font to black, or to change the yellow interior to white. " wrote: I have an excel form, it contains 3 different colors in the worksheet and I want to print all except the color yellow is this possible. I want to print the all the cells only don't print the color yellow. (print back and white) where yellow. thanks- Hide quoted text - - Show quoted text - Could you help me with the code, I would like to change the yellow interior to white. Thanks. Maybe this can help you Sub Macro5() ' ' Macro5 Macro ' Macro recorded 29/10/2007 ' ' Change selected cells Colour to No fill Range("A1:M1").Select Selection.Interior.ColorIndex = xlNone 'Insert your print macro ' Change Selected cells back to yellow colour Range("A1:L1").Select With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With Range("A2").Select End Sub- Hide quoted text - - Show quoted text - Thanks it worked, I made some adjestments and it works. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Printing a heading on each new page when printing | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) | |||
Printing? Worksheets not printing the same on multiple pc's! | Excel Programming |