need code for changing the fill color of cells to white when printing, then change back when printing is compelte

[kbishop94]

I have a worksheet where the background color of the sheet (using fill color) is tan like color, but when the user goes to print the worksheet I just need it to print with no fill, but I want it to change back to the original fill color when printing is done. Thank you

 

[steve the fish]

Maybe something like this will work:

With Sheets("Sheet1")
    myColor = .Range("A1").Interior.Color
    .Cells.Interior.Color = xlNone
    .PrintOut
    .Cells.Interior.Color = myColor
End With

They will need to run the macro to print rather than press the print button

 

[kbishop94]

Maybe something like this will work:

With Sheets("Sheet1")
    myColor = .Range("A1").Interior.Color
    .Cells.Interior.Color = xlNone
    .PrintOut
    .Cells.Interior.Color = myColor
End With

They will need to run the macro to print rather than press the print button

Thats perfect. Did the trick. Thank you Steve.

Now, I also have several Objects on the sheet that are also filled with color. What code would I add to this to have either all the objects on the sheet NOT filled, or, individual ones not filled when printing? Thank you again

 

[steve the fish]

Do they all have the same fill colour?

 

[kbishop94]

Do they all have the same fill colour?

No. Its an org chart and I am limiting control over what the user can and cannot do. Additionally, because of the color of the worksheet I dont need it nor want it to print out in color on our printer. Here is the snippet of the sheet to give you an idea of what I am working with. I decidde against using the installed excel (or even word for that matter) template for an org chart because some of the features I have in this one is not possible using the supplied template. THanks again!

 

[kbishop94]

Do they all have the same fill colour?

Never mind, I got it (you got me far enough along with the code, and from there I was able to record a macro and copy and paste that code into the code you supplied. Thanks for your help!)