+ Reply to Thread
Results 1 to 6 of 6

Unable to edit or add ActiveX controls

  1. #1
    Registered User
    Join Date
    12-02-2011
    Location
    Beijing, China
    MS-Off Ver
    Excel 2010
    Posts
    36

    Unable to edit or add ActiveX controls

    Hi,

    I have been working on a model that uses buttons and ActiveX controls. Suddenly I am unable to format my toggle buttons and they are inactive. I can't even select the button to delete it. I am also unable to add active x controls. Is it possible I deleted a certain library or some other file?

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Unable to edit or add ActiveX controls

    did you protect the worksheet?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    12-02-2011
    Location
    Beijing, China
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Unable to edit or add ActiveX controls

    No, it's not protected.

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Unable to edit or add ActiveX controls

    and you are using xl2010?

  5. #5
    Registered User
    Join Date
    12-02-2011
    Location
    Beijing, China
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Unable to edit or add ActiveX controls

    Yes, 2010. I'm going through VB Editor--Tools--References and checking which Active X reference is being used. The Microsoft ActiveX Data Object (Multi_dimensional) 2.8 Library is checked.

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Unable to edit or add ActiveX controls

    that does not relate to activex controls. the normal activex controls are from the ms forms 2.0 library.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1