Thanks Peter, but I wanted to do it with one click. My toolbars are too big
already and I wanted colored borders.

"Peter T" wrote:

There are built-in buttons to do that and similar.

Customize toolbars, Commands, Format

Scroll down the list of commands until you find the Border button you want
and drag onto your toolbar. One of the buttons is a like the colour format
button which drops down to a commadbar with all the border buttons.

Regards,
Peter T

"Liz" wrote in message
...
I would like to place a border at the press of a button around cells that
have been selected manually on a spreadsheet . Can anyone help, as I am
missing something?

Thanks