none
Macros disabled sometimes RRS feed

  • Question

  • Hi

    I have written some code in VBA Excel 2010 which runs fine on my Windows XP pc.

    When my colleagues (running Windows7, Excel 2010) try to use it they are told that: "This file contains encrypted macros that have been disabled because there is no antivirus software installed that can scan them........".

    I have written many other Excel 2010 (Windows XP) applications that work fine on my colleagues computers (Windows 7, Excel 2010) and have done a few more since the one that is causing the problem.

    The file is password protected, does that make a difference.

    Just to add to the fun, my company has a policy now that when a user is upgraded to a Windows7 account, the user cannot change the macro security settings.

    Can anyone help me with this?





    • Edited by Gazza101 Wednesday, October 10, 2012 11:31 AM
    Wednesday, October 10, 2012 9:31 AM

Answers

  • Thanks for the responses.

    I have managed to solve this one myself. The solution I discovered is along the lines of the link that Bernie suggested I read.

    It looks like my anti virus software cannot scan the vba code contained in the Excel 2010 file, because it is password protected and therefore encrytped.

    To solve the problem I had to save the file in Excel 2003 format, still password protected and now it works fine.

    thanks all.



    • Edited by Gazza101 Thursday, October 18, 2012 1:59 PM
    • Marked as answer by Gazza101 Thursday, October 18, 2012 2:00 PM
    Thursday, October 18, 2012 1:58 PM

All replies

  • Did you try this? It applies to Excel 2007, but may be helpful

    http://support.microsoft.com/kb/927150

    Wednesday, October 10, 2012 1:28 PM
  • Do you use API declarations in your code?

    Felipe Costa Gualberto - http://www.ambienteoffice.com.br

    Wednesday, October 17, 2012 11:13 PM
  • Thanks for the responses.

    I have managed to solve this one myself. The solution I discovered is along the lines of the link that Bernie suggested I read.

    It looks like my anti virus software cannot scan the vba code contained in the Excel 2010 file, because it is password protected and therefore encrytped.

    To solve the problem I had to save the file in Excel 2003 format, still password protected and now it works fine.

    thanks all.



    • Edited by Gazza101 Thursday, October 18, 2012 1:59 PM
    • Marked as answer by Gazza101 Thursday, October 18, 2012 2:00 PM
    Thursday, October 18, 2012 1:58 PM