View original (French)

Excel, do not print fill color

Solved
isocolt Posted messages 27 Status Member -  
 muguet4 -
Hello everyone,

I have an Excel sheet that I have protected except for a few cells.

These unlocked cells, I have colored them but I would like the color not to print when I print.

I tried recording a macro that sets them to white and then prints, but unfortunately, I get an error message when I run it.

I need your help to solve this problem or if you have another alternative.

Thank you in advance.

Configuration: Windows 7 / Safari 534.24

2 answers

  1.
    transat Posted messages 31956 Registration date   Status Contributor Last intervention   9 021
     
    Good evening
    Do you not have the option to print only in black and white in your printer settings?
    See you later
    --

    Curiosity on CCM is not a flaw but a quality
    0
    1. Anonymous user
       
      in B/W it will turn into more or less dark grey (what I have with my laser!!) depending on the color
      0
  2. isocolt Posted messages 27 Status Member 2
     
    Yes, of course, but that's not what I'm trying to do.

    If I print in black and white, my cell will be gray. I want it to be white, basically no fill.
    0
    1. transat Posted messages 31956 Registration date   Status Contributor Last intervention   9 021
       
      Ok, with my apologies
      0
    2. Anonymous user
       
      Well... I might say something silly since I've never tried it, but in the Excel printing options, if you check "black and white" in the "sheet" tab of the page layout (not in printer), what does that do??
      2
    3. isocolt Posted messages 27 Status Member 2
       
      It gives what I wanted to do!!

      Great, thank you very much HOMBOURGEOIS
      2
    4. Anonymous user
       
      Well there you go, I even learned something LOL
      1
    5. isocolt Posted messages 27 Status Member 2
       
      Just for your information, if you have texts in color and you want to keep them in color, it doesn't work.
      0