User Can't Select Form Control Option Button

[rjbinney]

Yes, it's football pool time again.

I have a worksheet where the user clicks on the team's helmet, and it selects their pick for this weekend's games.

I did it by inserting a Form Control Option button, then in Properties, added the bitmap of the helmet. The worksheet is OUT of Design mode, and protected.

I first created the form in Excel 2007, but have modified it extensively in Office 15 (whatever year that's supposed to be these days).

I have tried the form on two machines, both running Windows 7-64; one running Office 2010 and the one that I modified the form on (Office 15). In both cases, when I clicked on the helmet, the correct "True" value was generated.

I have one colleague - running Office 13, also on a Win 7-64 machine, who can NOT select the helmet. His cursor changes from the "PLUS" symbol to the pointer as he hovers over it, but it does not seem to do anything. I have heard no complaints from other colleagues.

We have unprotected the sheet and tried, reprotected it and tried, rebooted and tried, I've saved the form as a 2003-2007 compatible file, and still nothing.

We've tried changing the Macro Settings in the Trust Center, and have changed the "Trust Access to VBA object model" settings - mine were checked, his were not; we swip-swapped, and mine still worked fine with it deselected, and it seemed to make no difference on his.

Where should I be looking to get his sheet working properly?

Thanks in advance, and Hi, Kate.

rjb

 

[jtakw]

Try this:

Click on Large Banner on top of page: Are you here because your controls (such as the buttons you press to run macros) are no longer working properly? Read this: Form Controls stop working [properly] after December 2014 Updates

 

[rjbinney]

Well, hey, that's not too embarrassing.

 

[rjbinney]

Actually, my Googling had turned up that page earlier (before posting here) - but he doesn't report receiving any error messages. The way I read the description, users were either receiving those messages OR "ActiveX" controls weren't working properly; I presumed that Form controls were NOT the same as ActiveX, and so I disregarded it.

 

[GTO]

...I did it by inserting a Form Control Option button, then in Properties, added the bitmap of the helmet. The worksheet is OUT of Design mode, and protected. .........

Greetings,

I may well be missing something, but those three bits make me think you actually have added an ActiveX Option Button.

Mark

 

[jtakw]

Well, hey, that's not too embarrassing.

Nothing to be embarrassed about, as long as it works out at the end.:wink:

 

[rjbinney]

Greetings,

I may well be missing something, but those three bits make me think you actually have added an ActiveX Option Button.

Mark

The highlighted above is what I selected; I presumed that the "Form" and "ActiveX" were different families.

 

[GTO]

Form controls and ActiveX controls are indeed different. I was saying that where you seemed to have used the picture property and have Design Time in effect when dealing with the control, this would, AFAIK, indicate an ActiveX control, as I do not believe you can 'add a bitamap' to a Forms Option Button.

If you right-click and select the control, what is in the formula bar? If nothing is in the formula bar and the default name is akin to "Option Button 1" (w/spaces), it's a Forms Control. If "=EMBED("Forms.OptionButton.1","")" is in the formula bar and the default name is like "OptionButton1" (CamelCaseAndNoSpaces), then it's ActiveX. Sorry if I added confusion.

Mark

 

[rjbinney]

=EMBED("Forms.OptionButton.1","")

So there you go.

Interesting... So I guess I selected Forms control, but once I added the whiz-bang gee-gaws to it, it became ActiveX?

Oh well.

That will teach me to try to be clever!

Thanks

 

[RoryA]

Interesting... So I guess I selected Forms control, but once I added the whiz-bang gee-gaws to it, it became ActiveX?

That would be a first.

It is confusing though since the ActiveX controls come from the MSForms library and are what you use on userforms, whereas the Form controls are from the Excel library and can't be used on userforms.