Page 1 of 2 12 LastLast
Results 1 to 10 of 12

enable a macro

This is a discussion on enable a macro within the Excel Questions forums, part of the Question Forums category; i have downloaded a workbook from the web with macros when i want to run the macro it tells me ...

  1. #1
    Board Regular
    Join Date
    Sep 2002
    Posts
    141

    Default

    i have downloaded a workbook from the web with macros when i want to run the macro it tells me the macros are disabled can any one tell me please how to enable a macro

    Thanking you in advance

  2. #2
    MrExcel MVP Richie(UK)'s Avatar
    Join Date
    May 2002
    Location
    UK
    Posts
    3,330

    Default

    Hi ebraun

    You need to select 'Enable Macros' when you first open the workbook.

    HTH
    Richie

  3. #3
    Board Regular
    Join Date
    Sep 2002
    Posts
    141

    Default

    how do i do that ?

  4. #4
    Board Regular
    Join Date
    May 2002
    Posts
    810

    Default

    Study the Help files.


  5. #5
    Board Regular
    Join Date
    Sep 2002
    Posts
    141

    Default

    can anyone help me please

    Thanks

  6. #6
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default

    Hi ebraun:

    What version of Excel are you using? On later versions of Excel, because of Security concerns, the macros must be either certified to be from a trusted source, or the user has to take the responsibility of setting the security level to low to permit the macros to run.

    So, here is what you might want to try:

    1. Open Excel -- then go to TOOLS|MACRO|SECURITY ... set it to low
    2. Exit Excel
    3. Open Excel again, open your file -- and see if the macros will run now

    Please post back if it works for you -- otherwise explain a little further and let us take it from there. And as Stevebausch has suggested, you should also look into the Help files for relevant information.

    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  7. #7
    Board Regular
    Join Date
    Sep 2002
    Posts
    141

    Default

    thank you it worked

  8. #8
    Legend just_jon's Avatar
    Join Date
    Sep 2002
    Location
    Alabama/State of Disarray
    Posts
    10,473

    Default

    Applying the setting to Medium may also work, and adds a degree of security.

    just_jon
    Book of the Month: I'm Not Really an MVP, I Just Play One on TV [j. jon, 2004]

  9. #9
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Allentown, PA
    Posts
    2,543

    Default

    For searchers...

    In Excel 97, you have two options: Macro Virus Protection is either OFF or ON. The setting is under Tools-Options, General tab.

    In Excel 2000, you have three options:
    Low: You are not asked and macros are ENABLED always.
    Medium: You are asked whether to enable macros or not. (recommended if you're unsure which option to pick)
    High: You are not asked, and macros are DISABLED always.
    The settings are under Tools-Macro-Security.

    In Excel XP:
    The options are the same as Excel 2000. Likewise, you can find the settings under Tools-Macro-Security. You can ALSO find the settings under Tools-Options, Security tab, Macro security button.


    ~Anne Troy

  10. #10
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default

    Hi Anne:

    Thanks for taking the initiative to bring it up for all recent versions of Excel.

    However, for Excel 97, selecting MACRO_VIRUS_PROTECTION to be ON does just as it says, check for among other things, whether a macro in the workbook being opened may contain a virus, but does not categorically prevent every macro from being permitted to run.

    This is from Excel 97:

    Checks workbooks for macros that might contain macro viruses. Turns on a built-in warning message that appears whenever you open a workbook that might contain macro viruses (that is, the workbook contains macros or customized toolbars, menus, or shortcuts). For more information about checking workbooks for viruses, click ..

    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

Page 1 of 2 12 LastLast

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