can you create a spot in Excel which you can turn on and off by c.
 

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

can you create a spot in Excel which you can turn on and offby c.
 

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?

can you create a spot in Excel which you can turn on and off b
 

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?

can you create a spot in Excel which you can turn on and offb
 

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?