showing unlocked cells?

**Banaticus** · 07-27-2009, 03:58 AM

I want to shade some cells to show that they're unlocked (which cells are ok to edit numbers in while the other numbers are calculated automatically), but I don't want them to print out in a different color -- I want those cells to print out in white just like every other cell.

Is this possible?

**DonkeyOte** · 07-27-2009, 06:40 AM

In truth it depends partly on how you're formatting the unlocked cells initially... my immediate thought would be to use Conditional Formatting in conjunction with a "flag" cell which determines as to whether or not you're in Print Mode (the value of which could be set manually or via the BeforePrint event if Macros can be enabled), ie assume you select the unlocked cells and apply a Conditional Format rule of:

=$Z$1=0

and set format for unlocked cells

If we then say that Z1 is the cell to hold "printing state" then by changing Z1 to be say 1 the format of those cells containing the Conditional Format rule will revert to their default formatted state... subsequently reverting to 0 (non-print state) will then reactivate the Conditional Format.

**martindwilson** · 07-27-2009, 06:48 AM

File/PageSetup/Sheet Tab, check Black and White
fill colour wont be printed
alternatively use a macro to copy sheet
remove interior colour
print
then delete sheet.
something like

Sub nocellcolourprint()
 
    
    Sheets("martins sheet").Copy Before:=Sheets(1)
    Cells.Select
    Selection.Interior.ColorIndex = xlNone
    
   ActiveSheet.PrintOut
    Sheets("martins sheet (2)").Delete
  
End Sub

**Banaticus** · 07-28-2009, 12:01 AM

So, no then.

**martindwilson** · 07-28-2009, 04:47 AM

er where does "no" come into it?
both solutions i gave you will work
the print black/white will change font colour as well though

**Banaticus** · 07-29-2009, 12:20 AM

No, because how those solutions would only work for me. I can't expect Excel-illiterate people to do those things on their own. I need something that I can set up and which "just works".

**martindwilson** · 07-29-2009, 06:22 AM

unlucky then. perhaps you had better educate the "illiterate" users or ban them from using excel !
i cannot believe a user is incapable of setting print to back/white. if they cant do that thay shouldnt be let near a PC and perhaps should be seeking alternative employment!