Once you have created a button, you can move your mouse pointer over it,
hold down the Ctrl key then left click to "Select" the button.
To move it click and drag the perimeter.
To resize move your mouse til you see the arrows over the perimeter. Drag
the arrow.
Change the Caption by simply typing a new word(s)
Change the font the same as if you had selected a cell.


"Grace" wrote:

Boy, are you right! It is very easy, although I would like to know, after
you assign the macro, is it too late to move the buttons around, change
their size, or move them around?

This is the best way to go, as it appears so impressive!

Thx to you and Bob. I am done on this thread, other than the non-critical
questions above.

"Chip" wrote in message
ups.com...
Has anyone in this thread taught you that it is VERY easy to assign a
macro to a button. Go to ViewToolbarsForms and you should get a
toolbar now which shows a variety of forms Click on the one entitled
"Button". Then you just drag it the size of the button you would like.
You can even add text to the button. Then to add the macro, right
click on it, choose assign macro and you can then just the select the
macro you have made. Then when the user clicks the button it will run
the macro.