+ Reply to Thread
Results 1 to 12 of 12

ActivX Controls working on my laptop but same not working on other same configured laptop

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    93

    Question ActivX Controls working on my laptop but same not working on other same configured laptop

    Dear Excel Experts,

    I have prepared an excel application form. I used ActivX control to hide/unhide sheets/row/columns etc.

    The same documents is generally used by my colleagues.

    Till yesterday, everything was going nicely...we use LAN for sharing documents...everyone was able to open the doucment and able to run ActiveX control..but from today morning...no one can run ActiveX control except me.

    When my colleagues click on the ActiveX control button, it blinks..but nothing happen....

    I don't know what happen....

    We all uses Win7 and MS Office 2007...

    Can some one help me to solve the problem.

    Jay

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: ActivX Controls working on my laptop but same not working on other same configured lap

    See this thread, and various others:

    http://www.excelforum.com/excel-prog...p-working.html

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: ActivX Controls working on my laptop but same not working on other same configured lap

    The problem might have been a recent update, have a look here Office Update Breaks Activex Controls.
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    01-13-2015
    Location
    Nova Lima, Brazil
    MS-Off Ver
    2010
    Posts
    5

    Re: ActivX Controls working on my laptop but same not working on other same configured lap

    I'm looking for a solution too.
    Take a look at : Form Controls stop working after December 2014

    Updateshttp://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/11/forms-controls-stop-working-after-december-2014-updates-.aspx

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: ActivX Controls working on my laptop but same not working on other same configured lap

    @EamonJMV: I said in my post:

    Perceived wisdom says search for *.exd files in the Temp folder and delete them. For whatever reason, that did not work for me.

    I resorted to taking the proverbial sledgehammer to crack this nut and simply deleted the contents of the Temp folder ... which worked on a 2007 machine and a 2010 machine. I did take the precaution of NOT permanently deleting the files and sub-folders and allowed them to go in the recycle bin, just in case.

    Touch wood, no issues so far and the ActiveX controls are, well, active again.

    Strictly speaking ... Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

  6. #6
    Registered User
    Join Date
    01-13-2015
    Location
    Nova Lima, Brazil
    MS-Off Ver
    2010
    Posts
    5

    Re: ActivX Controls working on my laptop but same not working on other same configured lap

    Hello, I dont see that I asked a question. Please read my post again "I'm looking for a solution too.
    Take a look at : Form Controls stop working after December 2014".
    EamonJMV

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: ActivX Controls working on my laptop but same not working on other same configured lap

    @EamonJMV: no, that's fair comment. But I'm not sure what value you feel you have added. The thread that I referred to included an answer from Ron Coderre. That answer also had the link to which you refer in your post..

    The phrase "I'm looking for a solution too" seems to imply that you haven't found one. How would you expect anyone to respond to that?

    The link describes a process that did not work for me and, apparently quite a few others. I explained what I did ... which did work for me and others have confirmed worked for them.

  8. #8
    Registered User
    Join Date
    01-13-2015
    Location
    Nova Lima, Brazil
    MS-Off Ver
    2010
    Posts
    5

    Re: ActivX Controls working on my laptop but same not working on other same configured lap

    OK, Understood.
    I thought at the time of the post that the solution was as per the Link. I have since discovered that once again Microsoft has let us dangling.
    Thanks
    EamonJMV

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: ActivX Controls working on my laptop but same not working on other same configured lap

    No problem. I understand how you feel. As I said, the solution mentioned did not work for me though others have clearly found that it worked for them. My approach was a bit more heavy handed but, on the basis that it is a Temp directory, I deleted everything that I could that was in it. Probably more than necessary but it doesn't appear to have caused any problems. Touch wood.

    There is still a know issue, as far as I am aware, about the default numbering of newly created controls. I do not have a workaround for that.

    Regards, TMS ... Line under?

  10. #10
    Registered User
    Join Date
    01-13-2015
    Location
    Nova Lima, Brazil
    MS-Off Ver
    2010
    Posts
    5

    Re: ActivX Controls working on my laptop but same not working on other same configured lap

    Again thanks.
    I will try your approach. Delete TEMP entirely and see what happens.
    Also I will endeavour to replace ActiveX Controls with Form Controls.


    Eamon

  11. #11
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: ActivX Controls working on my laptop but same not working on other same configured lap

    ActiveX Controls with Form Controls.
    Not quite the same ...

    Note: when I deleted the contents of the Temp directory, I allowed it to go to the Recycle bin. More often than not, I permanently delete temp files, but I thought this warranted caution.

  12. #12
    Registered User
    Join Date
    01-13-2015
    Location
    Nova Lima, Brazil
    MS-Off Ver
    2010
    Posts
    5

    Re: ActivX Controls working on my laptop but same not working on other same configured lap

    Hi again,
    I appreciate your advice.
    I am not trying to prolong this thread.

    I will do as you did. Delete to Recycle Bin.

    Thanks again.
    Eamon

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Move Office 365 from Old Laptop to New laptop
    By claudiahacks in forum Office 365
    Replies: 0
    Last Post: 09-09-2013, 04:33 AM
  2. how to migrate to new laptop
    By avveerkar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2006, 02:36 PM
  3. LAPTOP KEYPAD
    By MARTIN TREMBLAY in forum Excel General
    Replies: 1
    Last Post: 06-28-2005, 04:05 PM
  4. [SOLVED] Save as not working for laptop to desktop
    By Adra in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2005, 06:06 PM

Tags for this Thread

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