How To Enable Macros In Excel Permanently?
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
To enable macros in Excel permanently, you can open a blank workbook, click on the “File“ menu, then select “Options“. Next, choose “Trust Center“ in the left–hand pane, then click “Trust Center Settings“ and select “Macro Settings“. Finally, select either “Enable all macros“ or “Enable all macros (including digitally signed macros)“. The change will be applied to all workbooks going forward.