Working With White Text

[pepper2956]

I have an Excel file that is linked to a Powerpoint presentation. The presentation has a blue background, so the Excel text needs to be white. When I format the text to be white so it displays correctly in the presentation, I can not longer see it on the standard white background while editing within Excel. I do not want to change the background color within the cell using cell/format because the background shows up in the powerpoint presentation where I don't want it. How do I change the background in Excel for editing purposes ONLY.

 

[Smitty]

Welcome to the Board!

Why not just change the font color or back color to a manageable color temporarily, then change it back when you're done editing? Or am I missing something?

Smitty

 

[pepper2956]

The content of the spreadsheet is updated by another party who is not as well versed in making Excel and Powerpoint work together. The "pretty" is my responsibility.

 

[pepper2956]

When he opens the spreadseet, it looks like a blank worksheet and he messes it up before realizing the content was hiding.

 

[Smitty]

So complete your edits before giving end-users access to it.

Smitty

 

[Norie]

Anna

Why not put code in the workbook open event to change the font colour to a visible colour?

Then put code in the close event to change it as required for PowerPoint.

 

[pepper2956]

Can you explain how to do the "events"? I am not a programmer, so dumb it down if you can.

Smitty: I cannot complete edits because the numerical content is entered by the gentlemen (it is an engineering document).

 

[Smitty]

Smitty: I cannot complete edits because the numerical content is entered by the gentlemen (it is an engineering document).

In that case why not create a "dummy" sheet for him to enter the data, then use that one to feed your formatted sheet.

Smitty

 

[pepper2956]

I already did that, but was hoping posting here could help me arrive at a more streamlined solution. Having two versions of the spreadsheet also increases the chances of human error and constantly checking/changing the link to the Excel file within the Powerpoint document.

 

[Smitty]

Here's something like Norie was suggesting:

<font face=Tahoma>
<SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Workbook_Open()
    Sheets("Sheet1").Cells.Font.ColorIndex = 1
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>

<SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Workbook_BeforeClose(Cancel <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Boolean</SPAN>)
    Sheets("Sheet1").Cells.Font.ColorIndex = 2
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

It will set the font on sheet 1 to black when the wb is opened and white when it closes. Right-click the Excel icon and select View Code. The code gets pasted into the window that opens on the right. Then your PP format should be OK.

Smitty