Working With White Text

pepper2956

New Member
Joined
Sep 12, 2006
Messages
5
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.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
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

New Member
Joined
Sep 12, 2006
Messages
5
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

New Member
Joined
Sep 12, 2006
Messages
5
When he opens the spreadseet, it looks like a blank worksheet and he messes it up before realizing the content was hiding.
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536

ADVERTISEMENT

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

Smitty
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Sep 12, 2006
Messages
5

ADVERTISEMENT

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

Legend
Joined
May 15, 2003
Messages
29,536
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

New Member
Joined
Sep 12, 2006
Messages
5
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

Legend
Joined
May 15, 2003
Messages
29,536
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
 

Forum statistics

Threads
1,136,697
Messages
5,677,270
Members
419,683
Latest member
MrVBAConfused

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top