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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
