Broken active x controls!! Help please!

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Broken active x controls!! Help please!

  1. #1
    New Member
    Join Date
    Dec 2014
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Broken active x controls!! Help please!

     
    Hi,

    I downloaded an add-in this morning called "be graphic" to use maps in excel. The add-in didn't work so I un-installed. Afterward I tried to add an active x control to a spreadsheet and got the following message: "Cannot insert object". Additionally, my files with existing active x control buttons are no longer useable. I can't click any existing active x control buttons, but I can view their VBA code in design mode.

    In an attempt to trouble shoot this so far, I have:
    1) Uninstalled and re-installed office 2010
    2) 'Fixed' my Microsoft office using uninstall a program
    3) Cleared my excel settings using the registry
    4) Upgraded to office 365 (brand new excel)
    5) Rebooted my computer a million times

    I still have the same error! Any help would be greatly appreciated before I lose my mind!

  2. #2
    MrExcel MVP AlphaFrog's Avatar
    Join Date
    Sep 2009
    Posts
    15,473
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Broken active x controls!! Help please!

    A couple of suggestions:

    From the VBA Editor menu select Tools\References
    In the Available References list, is there any item(s) that are checked that start with the term "Broken" or "Missing"? If yes, uncheck it\them.

    If you have a Personal Macro workbook, delete or rename it to disable it.
    Where is the Excel Personal Macro Workbook Located?

    In the VBA Editor's Project Explorer window (usually on the left), do you see any suspicious projects listed? There may be legitimate ones listed. Report back all your listed projects.
    Paste your Excel data to the forum...
    MrExcel HTML Maker or Excel Jeanie

    How to post your vba code
    [CODE]your VBA code here[/CODE]
    The # button in the forum's editor will apply CODE tags around your selected text.

  3. #3
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    30,378
    Post Thanks / Like
    Mentioned
    31 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Broken active x controls!! Help please!

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

  4. #4
    New Member
    Join Date
    Dec 2014
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Broken active x controls!! Help please!

    Quote Originally Posted by AlphaFrog View Post
    A couple of suggestions:

    From the VBA Editor menu select Tools\References
    In the Available References list, is there any item(s) that are checked that start with the term "Broken" or "Missing"? If yes, uncheck it\them.

    If you have a Personal Macro workbook, delete or rename it to disable it.
    Where is the Excel Personal Macro Workbook Located?

    In the VBA Editor's Project Explorer window (usually on the left), do you see any suspicious projects listed? There may be legitimate ones listed. Report back all your listed projects.
    Didn't see any broken/missing items, below are a list of my VBA projects:
    atpvbaen.xls(ATPVBAEN.XLAM) - not sure what this is
    EuroTool(EUROTOOL.XLAM) - I believe this is a built in add-in
    Solver(SOLER.XLAM) - I believe this is a built in add-in
    VBAProject(Book1) - Current project?
    VBAProject(FUNCRES.XLAM) - Not sure what this is
    VBAProject(PERSONAL.XLSB) - personal macros, etc

    Should I remove the ones I'm unsure of?

    Will try renaming personal now... Thank you for all the advice!!!

  5. #5
    MrExcel MVP AlphaFrog's Avatar
    Join Date
    Sep 2009
    Posts
    15,473
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Broken active x controls!! Help please!

    Funcres is for the Excel Analysis Toolpack and atpvbaen is for the VBA Analysis Toolpack. Tey should bo okay.

    Otherwise, I'm out of suggestions.
    Paste your Excel data to the forum...
    MrExcel HTML Maker or Excel Jeanie

    How to post your vba code
    [CODE]your VBA code here[/CODE]
    The # button in the forum's editor will apply CODE tags around your selected text.

  6. #6
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    30,518
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Broken active x controls!! Help please!

    Did you read the link Rick posted?

  7. #7
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    35,585
    Post Thanks / Like
    Mentioned
    23 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Broken active x controls!! Help please!

    Quote Originally Posted by Rick Rothstein View Post
    Rick's link resolved the issue for me. Thanks Rick!
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007 - Windows 10, 7
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules & Forum Use Guidelines

  8. #8
    New Member
    Join Date
    Dec 2014
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Broken active x controls!! Help please!

      
    Quote Originally Posted by Rick Rothstein View Post
    Thanks so much Rick, this fixed it! Saved me a lot of headache...

User Tag List

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