Results 1 to 5 of 5

Macros are disabled and I cannot enable them

This is a discussion on Macros are disabled and I cannot enable them within the Excel Questions forums, part of the Question Forums category; At work, the majority of our computers have suddenly lost the ability to run Excel macros, which we use frequently. ...

  1. #1
    New Member
    Join Date
    Feb 2003
    Posts
    26

    Default Macros are disabled and I cannot enable them

    At work, the majority of our computers have suddenly lost the ability to run Excel macros, which we use frequently. We employ multiple Windows operating systems (XP or Wondows 7 Pro) and either Excel 2007 or 2010. The two computers that can still run macros are newer Win7 Pro and Excel 2010.

    The frustrating part is that I have enabled marcos and VBA Project Object model access on my Excel and this does not fix it. I have also added the file location as a trusted document as well. There is not notification pop-ups of any kind to give me a clue.

    We work in a small company so there would not have been any administrative security changes without my involvement.

    My guess is that this is a Microsoft OS or Excel update that can caused a change. Does anyone know of such and issue or know where I can look it up? Internet searches have not provided any answers.

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    14,833

    Default Re: Macros are disabled and I cannot enable them

    The files did get saved as xlsm didn't they ??
    Also, try

    Make sure that events are enabled. In the code window press CTRL + G then in the Immediate window type

    Application.EnableEvents=True

    then press Enter.
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  3. #3
    New Member
    Join Date
    Feb 2003
    Posts
    26

    Default Re: Macros are disabled and I cannot enable them

    Thanks Michael M.

    I am saving as .xlsm.

    I have tried enabling the event and that does not seem to have an affect.

    What is curious is that I can run the code through the VB window. It's my macro control button that is disabled.

    Please let me know if you have any additional suggestions.

  4. #4
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    14,833

    Default Re: Macros are disabled and I cannot enable them

    Is it an ActiveX control Button ?
    There has been a recent update to Office that seems to have broken these controls

    See Here:

    Office Update breaks ActiveX controls | Excel Matters
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  5. #5
    New Member
    Join Date
    Feb 2003
    Posts
    26

    Default Re: Macros are disabled and I cannot enable them

    Thank you. I will research this. Sounds like that should be it.

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com