Remove macros from Microsoft Excel 2003 workbook

35 pts.
Tags:
Email attachments
Excel 2003
Excel 2003 macros
Excel macros
I am wondering if there is an easy way to remove macros from an Excel 2003 workbook. Several of our users have had emails with Excel attachments rejected due to the macros they contain.

Answer Wiki

Thanks. We'll let you know when a new response is added.

In Excel, press Alt-F11 to open the VBIDE. Right click on the module names to remove or export them, before emailing the workbook. –JP

To disable macros, click ‘Tools’ – ‘Options.’ When the ‘Options’ dialog box appears, click the ‘Security’ tab. Click ‘Macro Security. In the ‘Security’ dialog box , select the ‘Security level’ tab. Here you can set the macro security level to low, medium, high or very high. Under the “Very High” setting, only macros installed in trusted locations will be allowed to run. All other signed and unsigned macros are disabled. You can disable all macros entirely by setting your security level to Very High and disabling macros installed in trusted locations. To disable macros installed in trusted locations, click Tools, then select Macro and Security, and then click on the Trusted Publisher tab and “uncheck” the Trust all installed add-ins and templates option.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Iamabadger
    Thank you for your quick response AndreaF! One remaining question that I have is whether the following scenario would be successful since this issue is also related to Outlook. 1. Set workbook security to Very High and then save workbook 2. Attach workbook to email 3. Send email to recipient 4. Recipient receives email with attachment and is able to open it sucessfully
    35 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following