Scribd Logo
Upload

Welcome to Scribd!

  • 4K views

    Excel How To Enable Macros

    Uploaded by

    Rupert Parsons
    For Excel 2000 - 2003, Excel 2007 & Excel 2010 - 2013. This resource also explains how to change the security settings for macros & ActiveX controls.

    Copyright:

    Attribution ShareAlike (BY-SA)
    Download as PDF, TXT or read online from Scribd

    Excel How To Enable Macros

    Uploaded by

    Rupert Parsons
    4K views25 pages
    For Excel 2000 - 2003, Excel 2007 & Excel 2010 - 2013. This resource also explains how to change the security settings for macros & ActiveX controls.

    Original Title

    Excel how to enable macros

    Copyright

    © Attribution ShareAlike (BY-SA)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    For Excel 2000 - 2003, Excel 2007 & Excel 2010 - 2013. This resource also explains how to change the security settings for macros & ActiveX controls.

    Copyright:

    Attribution ShareAlike (BY-SA)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    4K views25 pages

    Excel How To Enable Macros

    Uploaded by

    Rupert Parsons
    For Excel 2000 - 2003, Excel 2007 & Excel 2010 - 2013. This resource also explains how to change the security settings for macros & ActiveX controls.

    Copyright:

    Attribution ShareAlike (BY-SA)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 25
    At a glance
    Powered by AI
    The document provides instructions on how to enable macros and change security settings in different versions of Excel (2000-2003, 2007, 2010-2013).

    To enable macros in Excel 2000-2003, you need to click 'Enable Macros' if a security warning appears when opening a file with macros. If an error message appears, you may need to change the macro security level.

    To change the macro security level in Excel 2000-2003, you go to the Tools menu, select Macro, then Security. Select 'Medium' and click OK.

    Excel How to enable macros

    Excel 20002003, Excel 2007 & Excel 20102013 This resource also explains how to change the security settings for macros & ActiveX controls

    Rupert Parsons 2013

    Copyright
    Excel How To Enable Macros Copyright 2013 Rupert Parsons This document is licensed under the Creative Commons Attribution Share Alike License version 3. You may copy, distribute and/or modify it under the conditions stipulated in the copyright licence. Click the link below to view the details of the copyright licence which applies to this publication: http://creativecommons.org/licenses/by-sa/3.0/deed.en

    Author y Feedback
    Author: Rupert Parsons If you would like to make any comments or suggestions about this guide please write to me at: [email protected] or leave a comment on Scribd / Sourceforge.

    Rupert Parsons 2013

    Table of Contents
    Excel 2000-2003 ............................................................................................................................................. 1 How to enable macros...................................................................................................................................... 2 How to change the macro security level........................................................................................................... 4 Excel 2007....................................................................................................................................................... 7 How to enable macros...................................................................................................................................... 8 How to change the security settings for macros & ActiveX controls................................................................10 Excel 2010-2013............................................................................................................................................ 15 How to enable macros.................................................................................................................................... 16 How to change the security settings for macros y ActiveX controls................................................................18

    Rupert Parsons 2013

    Excel 2000-2003

    Rupert Parsons 2013

    How to enable macros


    Open the spreadsheet (with macros):

    If a dialogue box Security Warning appears: Click Enable Macros

    Rupert Parsons 2013

    If an error message appears If one of the error messages below appears, the macros & any command buttons on the spreadsheet will not work because the macro security level selected is too high:

    To select the correct security level in order for the macros and command buttons to function: Close the spreadsheet. Follow the instructions on the next page: How to change the macro security level.

    Rupert Parsons 2013

    How to change the macro security level


    Go to the Tools Menu:

    Select Macro

    Rupert Parsons 2013

    Select Security

    The dialogue box Security appears:

    Rupert Parsons 2013

    Select Medium

    Click OK

    Rupert Parsons 2013

    Excel 2007

    Rupert Parsons 2013

    How to enable macros


    Open the spreadsheet (with macros):

    A message bar will probably appear just below the ribbon interface... with one of the following messages: Security Warning Some active content has been disabled or: Security Warning Macros have been disabled or: Security Warning ActiveX controls have been disabled

    Click Options

    Rupert Parsons 2013

    A dialogue box Security Alert appears Select Enable this content

    Click OK (to close dialogue box) If the macros / command buttons do not work after following the above instructions: The macros & any command buttons on the spreadsheet will not work because the security levels selected for macros and ActiveX controls are too high. (note that a command button is an ActiveX control). To select the correct security levels in order for the macros and command buttons to function: Close the spreadsheet. Follow the instructions on the next page: How to change the security settings for macros & ActiveX controls

    Rupert Parsons 2013

    How to change the security settings for macros & ActiveX controls
    In order for the macros and command buttons to function correctly, the following security settings for macros and ActiveX controls should be selected: For Macros: Disable all macros with notification For ActiveX: Prompt me before enabling all controls with minimal restrictions To access & change the security settings for macros & ActiveX controls you have to go to the Trust Center in Excel: The Trust Center Click the Microsoft Office button

    Rupert Parsons 2013

    10

    Select Excel Options

    Select Trust Center

    Rupert Parsons 2013

    11

    Click Trust Center Settings... (to open the trust center):

    To change the macro security settings in the Trust Center Select Macro Settings

    Rupert Parsons 2013

    12

    Select Disable all macros with notification (under the options for Macro Settings)

    To change the ActiveX security settings in the Trust Center Select ActiveX Settings

    Select Prompt me before enabling all controls with minimal restrictions (under the options for ActiveX Settings for all Office Applications)

    Rupert Parsons 2013

    13

    Click OK (to close the trust center):

    Rupert Parsons 2013

    14

    Excel 2010-2013

    Rupert Parsons 2013

    15

    How to enable macros


    Open the spreadsheet (with macros):

    If a message bar appears just below the ribbon interface with the following message: Security Warning Some active content has been disabled or: Security Warning Macros have been disabled or: Security Warning ActiveX controls have been disabled

    Click Enable Content

    Rupert Parsons 2013

    16

    If the macros / command buttons do not work after following the above instructions: The macros & any command buttons on the spreadsheet will not work because the security levels selected for macros and ActiveX controls are too high. (note that a command button is an ActiveX control). To select the correct security levels in order for the macros and command buttons to function: Close the spreadsheet. Follow the instructions on the next page: How to change the security settings for macros & ActiveX controls

    Rupert Parsons 2013

    17

    How to change the security settings for macros y ActiveX controls


    In order for the macros and command buttons to function correctly, the following security settings for macros and ActiveX controls should be selected: For Macros: Disable all macros with notification For ActiveX: Prompt me before enabling all controls with minimal restrictions To access & change the security settings for macros & ActiveX controls you have to go to the Trust Center in Excel: The Trust Center Click in the green tab File

    Rupert Parsons 2013

    18

    Select Options

    Select Trust Center

    Rupert Parsons 2013

    19

    Click Trust Center Settings... (to open the trust center):

    To change the macro security settings in the Trust Center Select Macro Settings

    Rupert Parsons 2013

    20

    Select Disable all macros with notification (under the options for Macro Settings)

    To change the ActiveX security settings in the Trust Center Select ActiveX Settings

    Select Prompt me before enabling all controls with minimal restrictions (under the options for ActiveX Settings for all Office Applications)

    Rupert Parsons 2013

    21

    Click OK (to close the trust center):

    Rupert Parsons 2013

    22

    You might also like