FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Another way to enable macros for a specific workbook is via the Office Backstage view. Here’s how: Click the File tab, and then click Info in the left menu. In the Security Warning area, click Enable Content > Enable All Content.

Detailed explanation-2: -Steps to Make a Macro run When a Workbook is Opened In the window that appears, go to the left drop down menu and select Workbook: If the default text for Open doesn’t appear, then look to the right drop down menu and select Open from the list: Type whatever macro code you want to run in the middle and that’s it!

Detailed explanation-3: -Excel Event code makes this possible and it is easier than you think. Event code can run a macro based on a drop-down list, event code is VBA code stored in a worksheet module or workbook module.

Detailed explanation-4: -Step 1: In the File tab, click “options.” Step 2: In the “Excel options” dialog box, click “trust center settings” in the “trust center” option. Step 3: In the “macro settings” option, select “enable all macros.” Click “Ok” to apply the selected macro settings.