Follow the instructions on the next page: How to change the security settings for macros & ActiveX controls To select the correct security levels in order for the macros and command buttons to function: Close the spreadsheet. (note that a command button is an ActiveX control). 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Ī dialogue box Security Alert appears Select Enable this contentĬlick 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. How to change the macro security levelGo to the Tools Menu:Ī message bar will probably appear just below the ribbon interface. Follow the instructions on the next page: How to change the macro security level.

To select the correct security level in order for the macros and command buttons to function: Close the spreadsheet. 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: If a dialogue box Security Warning appears: Click Enable Macros How to enable macrosOpen the spreadsheet (with macros): 16 How to change the security settings for macros y ActiveX controls.18 8 How to change the security settings for macros & ActiveX controls.10 Excel 2010-2013. 2 How to change the macro security level. Click the link below to view the details of the copyright licence which applies to this publication: Īuthor y FeedbackAuthor: Rupert Parsons If you would like to make any comments or suggestions about this guide please write to me at: or leave a comment on Scribd / Sourceforge. You may copy, distribute and/or modify it under the conditions stipulated in the copyright licence. Excel How to enable macrosExcel 20002003, Excel 2007 & Excel 20102013 This resource also explains how to change the security settings for macros & ActiveX controlsĬopyrightExcel How To Enable Macros Copyright 2013 Rupert Parsons This document is licensed under the Creative Commons Attribution Share Alike License version 3.

How to disable macros in excel 97