Consulting

Results 1 to 8 of 8

Thread: Deactivated macros

  1. #1
    VBAX Regular
    Joined
    Dec 2008
    Posts
    11
    Location

    Question Deactivated macros

    I am quite new to VBA. I am working on a workbook that includes several macros, including a workbook open macro. These macros are not complex. When I try to execute the macros for testing or otherwise, Excell tells me that the macros have been desactivated for this project. I can run with no problem another project that has similar macros without getting the "deactivated message". I have changed the choice to either "accept all macros" or "deactivated macro with notification" in the management center for confidentiality without positive results. I have set the directory for the workbook in the "approved location" in the management center for confidentiality. No positive results. When I open the workbook I do not even get a message that the macros are deactivated. They simply do not run. When I get into the VBE module and try to execute any macros from that projet I get the message of "deactivated macros". This is not the first time that it happens to me. Last time I decided to start from scratch. How can I avoid this? Any suggestions about why I get deactivated macros for the projet that do not respond to changes in the management center for confidentiality. And how to solve the problem? Thanks.

  2. #2
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,362
    Location
    Greetings 23cp,

    What version of Excel are you using? (to wit: 2000, 2003, 2007)

    Mark

  3. #3
    VBAX Regular
    Joined
    Dec 2008
    Posts
    11
    Location
    Hi Mark,

    I use Excel 2007

    Claude

  4. #4
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,362
    Location
    Greetings Claude,

    Respectfully, you only need to post the reply once... Anyways, I'm sure that you'll get some help, but as 2007 is different and newer than what I have access to (2000 and 2003), it would be best to wait for a 2007 user to answer.

    Best of luck,

    Mark

    PS - Hey, I just realized that you just joined. Congratulations and Welcome :-) You will 'meet' some very nice folks here who are very helpful

  5. #5
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,362
    Location
    "Cat killin' curiosity" got the best of me, so called a buddy (Demosthine).

    Claude, take a looksee at the workbook that won't the code won't run in. Is the extension ".xlsx" ?

    If yes, open and saveas to extension ".xlsm".

    Does that help?

    Mark

  6. #6
    VBAX Regular
    Joined
    Dec 2008
    Posts
    11
    Location
    Hi Mark,

    Extension is xlsm from the beginning (saved as file supporting macros).

    Thanks

    Claude

  7. #7
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,362
    Location
    Sorry 'bout that. I am at a loss then. :-(

    Mark

  8. #8
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    duplicate post removed.
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

Posting Permissions

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