Thursday, November 17, 2016

Excel : Enable VBA in Excel

Enable VBA in Excel

To enable VBA
  1.  File > Options >Select Customise the Ribbon . 
  2. You then have tick the Developer box to allow the Developer icon to appear.

To allow the Excel to run programs included with spreadsheets. 
 File>Options > Trust Center > Trust Center Settings>Macro settings >select enable all macros.

No comments:

Post a Comment