If you use CommandButton's from the Control Toolbox toolbar, then you can
set its TakeFocusOnClick property to False... do this will keep the cell
selection selected when the CommandButton's is clicked.

--
Rick (MVP - Excel)


"Johnny E. Jensen" wrote in message
...
Hello NG

In a excel sheet i have 5 buttons. Colored red, green, blue, yellow and
purple.

The user must select some celles on the sheet and then click on a button.
The click should call a VBA code and place the button backcolor in the
selected cells.

My problem is that when the user clicks the button, the selected cells
disappears.
Is there a way to hold the selection until the user has clicked a button?

Kind regards

Johnny E. Jensen