make button - assign to cell
Thanks for your help.
"jacob" wrote in message
...
slip of the key on the last one, sorry.
To add a button to a sheet programmatically you can use
Set btn = ActiveChart.Shapes.AddFormControl _
(xlButtonControl, 35, 10, 30, 15)
where the numbers are position left, position top, width
and height. To locate it on a particular cell you'll need
to set these parameters to the right values.
jacob
-----Original Message-----
Is it possible to programatically make a button and
assign its location to a
specific cell or cells?
--
Thanks,
DL
.
|