Double Underline Icon in XP

stef...@bellsouth.net

unread,

Jan 26, 2002, 11:23:47 AM1/26/02

to

In excel XP, when the toolbar is customized with the
double underline icon added, and you select the double
underline icon, it only single underlines. Anyone else
experienced this?

stef...@bellsouth.net

unread,

Jan 26, 2002, 11:36:41 AM1/26/02

to

Actually it is under format bottom double border icon,
rather than double underline.

>.
>

John Walkenbach

unread,

Jan 26, 2002, 11:45:15 AM1/26/02

to

I just tried it (using Excel 2002), and it works as expected.

Also, be aware that you can Shift-Click the normal underline button to get
double-underline.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss

<stef...@bellsouth.net> wrote in message
news:e4c001c1a685$d4f8a250$b1e62ecf@tkmsftngxa04...

Debra Dalgleish

unread,

Jan 26, 2002, 12:14:16 PM1/26/02

to

I get the same result with the bottom double border icon, though the one
in the border dropdown works properly.

Debra Dalgleish

unread,

Jan 26, 2002, 12:25:40 PM1/26/02

to

So we can remove many of the buttons on our toolbars! (now we only need
one Sort, Indent, Decimal, L/R Align)

Dave Peterson

unread,

Jan 26, 2002, 6:28:23 PM1/26/02

to

I added the button to my toolbar and recorded a macro to see what it was doing.
I got this important part:

With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With

When I did Format|Cells|Border, I got this:

With Selection.Borders(xlEdgeBottom)
.LineStyle = xlDouble
.Weight = xlThick
.ColorIndex = xlAutomatic
End With

===
Well, I thought it was interesting...

--

Dave Peterson
ec3...@msn.com

Debra Dalgleish

unread,

Jan 26, 2002, 6:52:44 PM1/26/02

to

Definitely interesting -- someone who's recorded a macro with all the
details should probably submit this <g>

Dave Peterson

unread,

Jan 26, 2002, 8:44:50 PM1/26/02

to

What torture!

Submitted.

--

Dave Peterson
ec3...@msn.com

Dave Peterson

unread,

Jan 31, 2002, 8:42:30 PM1/31/02

to

I think I'm in the right spot this time!
--Copied from a wrong thread, but wisely editted (or edited)--

Debra and I have been corresponding with a person at MS via the bug reporting
system. After a few screen shots and emails, they confirm that this is a
problem.

Debra suggests the following, but she's allowing (forcing) me to post this:

1. Add the following procedure to your Personal.xls or other workbook
that opens automatically when Excel starts.

Sub BottomDoubleBorder()

With Selection.Borders(xlEdgeBottom)
.LineStyle = xlDouble
.Weight = xlThick
.ColorIndex = xlAutomatic
End With

End Sub

2. Choose Tools>Customize, and click the Commands tab.
3. Select the Format category, and add the Bottom Double Border button
to any toolbar.
4. Select the Macros category, and add the Custom Button to any toolbar.
5. Right-click on the Custom button.
6. Choose Assign Macro, select the BottomDoubleBorder macro, click OK
7. Right-click on the Bottom Double Border button
8. Choose Copy Button Image
9. Right-click on the Bottom Double Border button
10. Choose Paste Button Image
11. Drag the Bottom Double Border button off the toolbar.
12. Close the Customize dialog box.

--

Dave Peterson
ec3...@msn.com