Tuesday, July 31, 2012

8. Excel macro security

In Excel 2003 by default will display a security warning dialog box when the user opens the workbook in which there are macros. Above dialog box warning that the workbook that you have nuka macros. This warning is given to prevent dangerous dijalakanya macros. If you do not recognize the macros in the workbook, press the Disable Macros to disable macros. If you know the macros in the workbook and was intending to use it, press the Enable Macros to enable macros.


  • To facilitate the creation of applications that I discuss at this time, the security warning dialog box to temporarily disable our first, perform the following steps:Select the menu Tools> Macro> Security ... Security dialog box appears as shown below.


  • Select the Security Level tab. To be included in the workbook Macro always run without a Security Warning dialog box, select Low.
  • Select the tab Trused Publishers. Tick ​​the option Trust installled all add-ins and templates and Trust access to Visual Basic Project. press the OK

5 comments: