MACRO SETTINGS
Usually, when you open up a Microsoft Excel workbook that contains Macros, it will open with a message saying that macros have been disabled, and ask you if you want to enable them.
However if your version of Excel does not do this, you can make it do so by following the instructions below.
However if your version of Excel does not do this, you can make it do so by following the instructions below.
To make a Microsoft Excel workbook containing macros automatically ask if you want to enable the macros when you open the spreadsheet:
- Open Microsoft Excel
- Click the File tab.
- Click Options.
- Click Trust Center, and then click Trust Center Settings.
- In the Trust Center, click Macro Settings.
- Click the "Disable all macros with notification" option as in the screenshot below, then click OK
You can find more details about macros on the Microsoft web page here.