How to enable macro in Excel 2021
Hey everyone, welcome back to our Excel tutorials! Today, we're looking how to enable macro in microsoft excel 2021.
If you can find out a button with warning message right above formula bar, labelled as "enable content" click it. That's enough.
If it's not there you have to follow these setps:
Step 1: Click the 'File' tab in the top-left corner of the Excel window.
Step 2: Navigate to 'Options' and click on it. This opens up the Excel Options dialog box.
Step 3: Now, click on 'Trust Center' in the menu on the left-hand side of the Excel Options dialog box.
Step 4: Click on 'Trust Center Settings...'.
Step 5: Click on 'Macro Settings'.
Step 6: Here, you'll find different options for handling macros. Click one that you prefer. To enable macro, click on enable option.
Check the option "enable excel 4.0 macros when VBA macros are enabled".
Step 7: Press 'OK' to save your changes and close the dialog box.
If you found this video helpful, give it a thumbs up, subscribe to our channel for more Excel tips and tricks, and leave a comment below if you have any questions or suggestions for future videos.
Download the file from:
https://drive.google.com/uc?export=do...
Watch video How to enable macro in Excel 2021 online without registration, duration hours minute second in high quality. This video was added by user iCals Digital Solutions 04 April 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 831 once and liked it 3 people.