How to Disable a Macros Using VBA Excel

1. Open the Excel workbook in which you want to change your macro settings.
2. Click the Microsoft Office icon button in the top, left of your window.
3. Select 'Excel Options' and click 'Trust Center.'
4. Click 'Trust Center Settings' and select 'Macro Settings.'
5. Uncheck the box for the security option 'Trust access to the VBA project object model.'
6. Click 'Apply' and close your settings windows.