+ Reply to Thread
Results 1 to 5 of 5

Macros are working on some computers on network but on others they are not

  1. #1
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2003
    Posts
    20

    Question Macros are working on some computers on network but on others they are not

    This is complicated.

    I have created a form in Excel with lots of macros (to make the magic of the form to happen) that is used by many users all over our network. The file has an open workbook macro that runs a bunch of things in the background before the file opens. For most people this works great and opens just like it is supposed to but for some (and it is random) they are getting the following error "Run-time error '32809': application-defined or object defined error" when we select Debug it is getting hung up on the open workbook macro that is calling for a particular tab to activate [sheets("General Info - Estimates Entry").activate]. I have googled this and many forums say that it more than likely is a system updating patches issue. I called my IT department and confirmed that if the users are restarting there computers every night and or asking for the updates (laptop users) then they will and are getting the network update patches. So what else could this be? Why would it work on some computers and not on others? Any and all help would be greatly appreciated.

    Thanks,
    Steven
    Last edited by 6StringJazzer; 10-27-2016 at 03:58 PM.

  2. #2
    Forum Contributor S O's Avatar
    Join Date
    06-25-2015
    Location
    England
    MS-Off Ver
    Office 2010 + 2013 + 2016
    Posts
    103

    Re: Macros are working on some computers on network but on others they are not

    Without actually seeing the code, it's near impossible to help. Please supply the relevant code in the procedure where the issue is happening.

  3. #3
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Macros are working on some computers on network but on others they are not

    Some users are getting the following error "Run-time error '32809': application-defined or object defined error" when we select Debug it is getting hung up on the open workbook macro that is calling for a particular tab to activate [sheets("General Info - Estimates Entry").activate].

    As requested, here is the Workbook_Open code on ThisWorkbook:
    Please Login or Register  to view this content.
    The sheet name that it is trying to activate is correct as it is a copy and paste from the tab itself.

    This is so puzzling and any help would be greatly appreciated.

    Thanks,
    Steven

  4. #4
    Forum Contributor S O's Avatar
    Join Date
    06-25-2015
    Location
    England
    MS-Off Ver
    Office 2010 + 2013 + 2016
    Posts
    103

    Re: Macros are working on some computers on network but on others they are not

    Sounds like they didn't install the patches when MS broke form controls last year....

    Have a read of this: http://excelmatters.com/2014/12/10/o...ivex-controls/

    Unfortunately, it has to be done individually on each machine (unless a network admin can do it for you)

  5. #5
    Forum Contributor S O's Avatar
    Join Date
    06-25-2015
    Location
    England
    MS-Off Ver
    Office 2010 + 2013 + 2016
    Posts
    103

    Re: Macros are working on some computers on network but on others they are not

    (duplicate - please remove this 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. Why wont my linked files open on other computers on the network?
    By gmr4evr1 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-14-2016, 03:50 PM
  2. Print to specific network printer from multiple computers
    By daj38 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2015, 03:54 PM
  3. Network domain changed, Macros no longer working
    By mrome74 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2013, 10:34 PM
  4. Excel formatting changes on network computers
    By Lilahbean in forum Excel General
    Replies: 1
    Last Post: 06-11-2013, 07:57 AM
  5. run macros on entire network of computers once clicked
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2012, 05:55 PM
  6. Macros on other computers....
    By Sparkybear in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2008, 09:47 AM
  7. Replies: 1
    Last Post: 08-11-2006, 05:30 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