+ Reply to Thread
Results 1 to 4 of 4

Macros not working on only 2 laptops!

  1. #1
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Manila, Philippines
    MS-Off Ver
    2019
    Posts
    102

    Macros not working on only 2 laptops!

    Run time error ‘32809’: Application-defined or Object-defined error

    This pesky error message has been haunting me for almost a week now and cannot seem to figure out what causes this show-stopper. I have done my research about this and did exactly as suggested, and so far I am done with:
    • Adjusting the macro security settings
    • Enabled the “Trust access to the VBA project object model” option under Developer Macro Settings
    • Matching the VBAProject References of a working unit against the faulty unit


    The only workaround I haven’t done so far is to reinstall the MSO of the faulty machines.

    What really puzzles me is that apart from my boss’ and his boss’ computers, my macro runs seamlessly on everyone. That is why I doubt if the problem is on the program. I created the program using Excel 2013, which all of the file’s recipients are using, including those two who are experiencing the problem. Even both ActiveX and userform buttons are not responding to their clicks!

    I did a test where I exported all the modules and userforms and copied all the codes in a fresh Excel workbook on one of the laptops in question. Just like reworking everything, and import all those components. And voila! It worked! But this workaround is definitely not what I am looking for.

    Should I take the last resort and ask them to have a fresh copy of their Excel 2013, or is there something I haven’t done yet to resolve this case?

    I would appreciate your help guys. Thanks.

  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,434

    Re: Macros not working on only 2 laptops!

    It could be the December ActiveX bug. Or it might be that event handling is disabled.

    https://support.microsoft.com/en-us/kb/3025036


    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 Contributor
    Join Date
    08-29-2012
    Location
    Manila, Philippines
    MS-Off Ver
    2019
    Posts
    102

    Re: Macros not working on only 2 laptops!

    @TMS, I saw that December ActiveX bug somewhere but did not pay too much attention to it, since I reckon if that is the culprit, all computers should encounter the same error. But the error only occurs to only 2 laptops, which of all people, are my boss and his boss.

    I'll try to investigate the link you provided, and will get back to you for hopefully, a reputation point!

    For the mean time, suggestions and workarounds are still acceptable.

    Thanks.

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macros not working on only 2 laptops!

    Hi ykobure

    I had the same issue several days ago.

    See this link for a fix approach...
    http://www.excelforum.com/excel-prog...r-32809-a.html
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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. Replies: 0
    Last Post: 12-16-2014, 10:12 AM
  2. [SOLVED] Macro "save file to folder" to work on co-workers laptops
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-15-2014, 12:08 PM
  3. XP macros not working in NT
    By DKS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2006, 06:40 AM
  4. Excel and Laptops
    By astrikor in forum Excel General
    Replies: 3
    Last Post: 02-12-2006, 07:29 PM
  5. Macros not working
    By neb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2005, 12:05 PM

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