Macros not working on other computer

  • Good Day

    I'm having a problem with a program I created using VBA. It works great on all of my computers. (I have 3 laptops: HP, Dell & Toshiba Satelite...& 1 desktop HP). I sent a copy of the program through our shared 'Dropbox' folder, to my daughter. She copied it to the desktop folder of her laptop and it isn't working properly... the macros are disabled. All errors seem related to 'not being able to run the macros as they may be disabled' etc. The program does open but none of the macros work. We get the 'Security Warning...and we checked the box "Enable this Content"...so that isn't the issue. I checked her "Excel" settings <Trust Center><Trust Center Settings><Macro & ActiveX settings>. They are the same as mine which allows macros, with permissions. The "Trust access to VBA object model" is also checked. I even set the folder that houses the program, as a "Trusted Location".

    Is there some setting in Windows 10 that disallows macros...BTW we both are using Windows 10 & Excel 2007. Her antivirus is Kaspersky (free) & I'm using AVG (Paid). Both hers and my firewalls are activated.

    Any help will be greatly appreciated.

    Thanks a ton

    JimmyB :/

    Thanks for your help

    JimmyB


    Some plans fail on execution

    All plans fail without

    8)

  • Check the file properties in explorer and see if there is an option to unblock the file.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • I didn't, it was just step one of ruling things out. :)


    Step 2: how are you running the macros?

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!