Excel: edit properties commandbutton on sheet

[Karja]

Goodmorning,

I've got a (probaly very silly) question:
I've written some VBA stuff to control some processes in Excel2003. On several worksheets I put some commandbuttons assiociated to macro's. This works fine.

But now I want to change the locations of the buttons and some other properties. The problem is that I can find out how to change those properties. It must be fairly simple but I just can't get it done. Any help appreciated.

Thanks in advance,

 

[xlbo]

which toolbar did you use to create the buttons ?? there are 2 different kinds of buttons and they have different ways to access their properties.

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Karja]

Geoff,

I just drew them on the sheet with the control toolbox.

Kind regards,

 

[xlbo]

in which case, you will need to click on the 'design' button before you can edit the properties - it is the one that looks like a blue /green set square. then just right click on the control and choose "properties"

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Karja]

Thank you very much. This is exactly what I was looking for. Strangly enough it was never mentioned in references on the Internet. Thanks again!