Excel XP Bottom Double Border Problem

[Eduardo]

I had previously corresponded with Debra on this subject,
and have
followed the suggestions on creating a macro for the
button. It works
while excel is open; but when I close and re-open excel it
does not
work. I have to re-assign the macro to the button. What
have I done
wrong? Is there a solution to this?

A couple of observations:
1) A few of the steps described in Dave Peterson's
suggestion can be
skipped: select tools > customize; right click on Bottom
Double Border
button (if it is already on toolbar - if not then go to
format & drag
the button to the toolbar); then assign macro, select name
of macro
you have created and click OK.

2)A possible workaround could be useful: when recording
macro (Tools >
Macro > Record Macro)select a shortcut button for the
macro (ie. I
used Ctrl + m). This shortcut will produce a Double Bottom
line when
used after re-starting excel.

If anyone has an answer to my question above, I would very
much
appreciate it.
Thanks, Eduardo

 

[Debra Dalgleish]

Did you save the macro in a workbook that opens automatically, when
Excel opens, e.g. Personal.xls?

 

[Eduardo]

Yes, it is saved in Personal.xls, this is located in the
XLSTART folder. Any other suggestions, thanks. E.

 

[Dave Peterson]

I followed those suggestions (actually Debra's--I don't write that well!).

It worked ok for me. I closed excel & reopened it. When I clicked on my custom
button, my workbook with the macro opened (if it wasn't already open) and did
the double underline.