rjbinney
Active Member
- Joined
- Dec 20, 2010
- Messages
- 304
- Office Version
- 365
- Platform
- Windows
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
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