+ Reply to Thread
Results 1 to 4 of 4

Why are my VBA code not working anymore on other machines?

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    Lisbonne
    MS-Off Ver
    Excel 2010
    Posts
    3

    Why are my VBA code not working anymore on other machines?

    Hi,
    I would be very pleased if anyone could help me with the following issue.
    I have a file, full of code which I shared with someone else last June and I was perfectly working on its computer.
    Now (since end of July) if I re-save the exact same file on my computer (not having made any modification, just re-saving) and share it with the other guy, he cannot run it anymore. He get a "Compile error in hidden module" and VBA seems not to recognize statement like "Private Sub".
    I am operating in Windows 7 / Office 2010 (The other computer as well) and both computers have up-to-date releases from Microsoft.
    Any idea?
    Thanks

  2. #2
    Registered User
    Join Date
    05-19-2015
    Location
    Australia
    MS-Off Ver
    365
    Posts
    6

    Re: Why are my VBA code not working anymore on other machines?

    I had this happen to me just a few weeks ago my solution was that i had Manual Calculations turned on i turned that off again and i was right as rain. dont know if that will help but that was my solution to when that happened to me.

    Cheers

  3. #3
    Registered User
    Join Date
    08-30-2012
    Location
    Lisbonne
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Why are my VBA code not working anymore on other machines?

    Quote Originally Posted by middow View Post
    I had this happen to me just a few weeks ago my solution was that i had Manual Calculations turned on i turned that off again and i was right as rain. dont know if that will help but that was my solution to when that happened to me.

    Cheers
    Thanks, I will try this and let you know (I have to wait till tomorrow since my counterpart is in Japan and already out of work at this time)

  4. #4
    Registered User
    Join Date
    08-30-2012
    Location
    Lisbonne
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Why are my VBA code not working anymore on other machines?

    Hi Middow. I have tested your solution but unfortunately, it doesn't change anything. Thanks anyhow

+ 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: 2
    Last Post: 11-13-2014, 10:40 AM
  2. VBA code not working anymore
    By random379 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2012, 03:01 AM
  3. VBA code "Application.FileSearch" not working in XL 2007 anymore
    By leecs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2010, 01:22 AM
  4. Code to insert functions not working anymore
    By Mike K in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2006, 09:00 AM
  5. [SOLVED] Filter is not working anymore.
    By Berry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2006, 02:45 AM
  6. VLOOKUP not working anymore
    By Phil in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-27-2006, 02:45 PM
  7. unselecting not working anymore?
    By Joe Magiera in forum Excel General
    Replies: 1
    Last Post: 08-31-2005, 11:05 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