How To Activate Macros In Excel?
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.
1. Open the Excel workbook that contains the macros you want to enable.
2. Click the “File” tab and select “Options.”
3. Select “Trust Center” from the left pane and click “Trust Center Settings.”
4. Select “Macro Settings” from the left pane.
5. Select “Enable all macros” and click “OK.”
6. Restart Excel to enable the macros.
1. Open the workbook containing the macro you want to activate.
2. Click the “Developer“ tab.
3. Click the “Visual Basic“ button in the Ribbon.
4. Double–click the worksheet containing the macro you want to activate.
5. Select the macro from the left–hand window.
6. Click the Run button at the top of the VB Editor window. The macro will execute immediately.