Page 1 of 2 12 LastLast
Results 1 to 10 of 20

ActiveX Option Button Control

This is a discussion on ActiveX Option Button Control within the Excel Questions forums, part of the Question Forums category; I created a workbook several weeks ago that was working beautifully until I got on it today and noticed none ...

  1. #1
    New Member
    Join Date
    Aug 2014
    Posts
    36

    Default ActiveX Option Button Control

    I created a workbook several weeks ago that was working beautifully until I got on it today and noticed none of the option button controls were working. When I go to properties to try and figure it out the properties don't even look the same. I had originally had to create a group of buttons that were all on the same row and name them all the same name (within the properties function) in order for Excel to recognize that within that group of buttons only 1 should be clicked at a time and have several rows of buttons that all buttons on a certain row have the same grouping. Like I said, it worked beautifully. Now, all of a sudden, the buttons don't even allow me to click them, the properties feature doesn't even give me the option to enter a "group name" anymore, and I also can't enter any more ActiveX Controls even if I wanted to because the error message "cannot insert object" pops up. I've googled the issue several times already and can't seem to understand what people are suggesting to change. Can anyone PLEASE help me!!!!!!

  2. #2
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    27,519

    Default Re: ActiveX Option Button Control

    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See here.

  3. #3
    New Member
    Join Date
    Aug 2014
    Posts
    36

    Default Re: ActiveX Option Button Control

    Thank you so much!!! When other people try to open this on their computers I order to fill out,if they have those *.exd files will it to allow them to click those buttons?

  4. #4
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    27,519

    Default Re: ActiveX Option Button Control

    Quote Originally Posted by smarie123 View Post
    Thank you so much!!! When other people try to open this on their computers I order to fill out,if they have those *.exd files will it to allow them to click those buttons?
    That is a good question but, unfortunately, I do not know the answer. I think you will have to try it out and see.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See here.

  5. #5
    New Member
    Join Date
    Aug 2014
    Posts
    36

    Default Re: ActiveX Option Button Control

    Ok so I deleted those files and it's still doing the same thing. I guess I'm one of those cases of it not correcting.

  6. #6
    New Member
    Join Date
    Aug 2014
    Posts
    36

    Default Re: ActiveX Option Button Control

    The "MSForms.exd- Excel8.0" one keeps coming back. The other one was able to delete and say deleted, but this on is a pest. Any ideas?

  7. #7
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    27,519

    Default Re: ActiveX Option Button Control

    Quote Originally Posted by smarie123 View Post
    The "MSForms.exd- Excel8.0" one keeps coming back. The other one was able to delete and say deleted, but this on is a pest. Any ideas?
    I think it is supposed to be recreated. As I understand the process, those ".exd" files must exist, but there was a conflict with the old (existing) ones and what the update required in them... once you deleted them and ran your code, the fact that they were missing caused new ones to be created... supposedly those new ones were the correct ones that the updated needed them to be.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See here.

  8. #8
    New Member
    Join Date
    Aug 2014
    Posts
    36

    Default Re: ActiveX Option Button Control

    So as I'm searching more and more into this I'm seeing that no updates were actually done on mine until December 11th and none of the update #'s match the ones that people are saying need to be uninstalled. I'm so confused!!!

  9. #9
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    27,519

    Default Re: ActiveX Option Button Control

    Quote Originally Posted by smarie123 View Post
    So as I'm searching more and more into this I'm seeing that no updates were actually done on mine until December 11th and none of the update #'s match the ones that people are saying need to be uninstalled. I'm so confused!!!
    Are you searching for update related to your particular version of Office (apparently different security updates where used for different versions of Office).
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See here.

  10. #10
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    2,041

    Default Re: ActiveX Option Button Control

    Quote Originally Posted by smarie123 View Post
    When other people try to open this on their computers I order to fill out,if they have those *.exd files will it to allow them to click those buttons?
    Yes, everyone having the evil *.exd files on their individual computers will have the same problem, they will need to remove them also.

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com