Borders
 

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

Borders
 

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

Borders
 

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

"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

Borders
 

Thanks Nick

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

"NickHK" wrote:

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

"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

Borders
 

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