can you create a spot/dot in Excel which you can turn on and off by clicking
on it?

There is a Toggle Button in ActiveX controls.

jennym wrote:

> can you create a spot/dot in Excel which you can turn on and off by clicking
> on it?

Thanks for that, that's very helpful. I've found the ActiveX controls (I
didn't know about their existence before!) and I think it's actually the
'Option Button' that I want. I've managed to create a button however I'm not
sure how I can edit the 'Properties' so that it turns 'on' when I click on it
and 'off' when I click on it again. I'm not very good with all the computer
speak in the long list of 'Properties'. Any ideas?

"Bob I" wrote:

> There is a Toggle Button in ActiveX controls.
>
> jennym wrote:
>
> > can you create a spot/dot in Excel which you can turn on and off by clicking
> > on it?
>
>

You would need two options buttons. When you select option button two,
option button one turns off, and vise versa.

jennym wrote:

> Thanks for that, that's very helpful. I've found the ActiveX controls (I
> didn't know about their existence before!) and I think it's actually the
> 'Option Button' that I want. I've managed to create a button however I'm not
> sure how I can edit the 'Properties' so that it turns 'on' when I click on it
> and 'off' when I click on it again. I'm not very good with all the computer
> speak in the long list of 'Properties'. Any ideas?
>
> "Bob I" wrote:
>
>
>>There is a Toggle Button in ActiveX controls.
>>
>>jennym wrote:
>>
>>
>>>can you create a spot/dot in Excel which you can turn on and off by clicking
>>>on it?
>>
>>