Borders

[Guest]

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

 

[Peter T]

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

 

[NickHK]

For the command button (if is from the Controls tool Box), have you set its
"TakeFocusOnClick" property to False ?

And you are using code like:
Selection.BorderAround xlContinuous

NickHK

 

[Guest]

Thanks Nick

it was the "TakeFocusOnClick" property to False that did it - I knew it
would be something simple I had missed!

 

[Guest]

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