Windows 7: PLEASE HELP -Freeze Panes Line Colour

roymunoz03 · 02 Aug 2010

Hi there,

this is a very rare issue, but it's real.

I recently installed Windows 7, and I noticed that when I use the freeze pane in Excel, the line color is grey (instead of black). I know this is caused by the Windows 7 theme because if I select the "Windows Classic" theme the line turns black again. My question is: what can I do to use a Windows 7 theme and still having a black freze pane line? It appears that Excel assigns the line color based on windows theme settings or something but I haven't figured out which property do I need to affect.

Please help me, that would be much appreciated. I want a black line for when I freeze the panes. Grey line is horrible..

Please see the screen for the 2 ways:

this is the wrong way using windows 7 theme (note that line can be seen over a group of black filled cells.)

PLEASE HELP -Freeze Panes Line Colour-capture1.png

this is the good way but it only comes when I select windows classic theme which is ugly (note that line cannot be seen this time because it is black as well as the group of cells)

PLEASE HELP -Freeze Panes Line Colour-capture2.png

Doc1.docx

roymunoz03 · 02 Aug 2010

help?

**yowanvista** · 02 Aug 2010

Which version of Excel are you using?
Could post a screenshot of the problem

roymunoz03 · 02 Aug 2010

Thanks, I am using Office 2010 32 bit version.

how do I post a screenshot here?

roymunoz03 · 02 Aug 2010

Hi Yowanvista, I attached a doc file with screenshots

**yowanvista** · 02 Aug 2010

Click on the Start Menu and start typing "snipping" into the search box.
Snipping Tool should show up in the Programs list above the search box, and you can click on it to start it.
The Snipping Tool window will appear on your screen. You may move it to an edge of the screen so it's not in your way, but it will also disappear when you start dragging a selection area.
The Snipping Tool assumes you want to create a new clipping as soon as you open it. Your screen will dim, and you can click and drag your cursor to select an area to copy. As you drag, the selected area will be darker, and surrounded by a red border if you've never changed the Snipping Tool options.
When you release the mouse button, the captured area will open in the Snipping Tool window. If you're not happy with the selection and need to try again, click the "New" button.
When you are happy with your clipping, press the second button to save the screen shot as an image file.

Then upload it by using this method: A Preferred Method of Uploading/Posting Screen Shots

roymunoz03 · 02 Aug 2010

thanks for the tip yowanvista

**yowanvista** · 02 Aug 2010

Quote: Originally Posted by roymunoz03

Hi Yowanvista, I attached a doc file with screenshots

There is no doc file, re upload it

roymunoz03 · 02 Aug 2010

ok, please check now on my original entry, you should be able to see the doc file and the screenshots, please let me know

roymunoz03 · 02 Aug 2010

ok, I managed to post some pictures and screenshots.

Windows 7: PLEASE HELP -Freeze Panes Line Colour

PLEASE HELP -Freeze Panes Line Colour problems?