Thanks Mile a biga DUH for me lol

"Khanjohn" wrote:

I open the Control tool Box, selcet the one to click. I cna edit name etc
but I can never get it to not allow me to resize it or edit it. what am I
doing wrong? I wnt to add a formula in the VBA part which I have tso that
when it is clicked it will random a number. Would liekth enumber in cell
below the button so as nto to have to sue F9. I have 2 cells in worksheet
that used randon numbers but if I click anything, type anything they
randomize. Kind of anoying. Only want them to work when I hit F9 or thsi
button. Would rather have the button.

How do I accomplish this?