However, if you are alterted to a macro attached to a document, you should be cautious as most users do not have macros in their documents. Macros detected by macro virus protection are not necessarily viruses.

Note: Enabling macro protection in Microsoft Word and/or Access (aka: macro virus protection) will not detect specific macro viruses for you but will inform you if a macro exists on a document you are trying to open. Currently, macro protection can only be configured for Excel in Office 2008.Place a check in the box next to Warn before opening a file that contains macros.Click once on the Security category listed on the left-hand side of the window to highlight it.Close the sheet Change the macro settings Reopen the sheet Close the sheet Change the macro settings. Is there an option is enable and disable macros on the fly without having to. However the VBA code messes around with the visibility of cells and thats a pest when editing the sheet. Instructions for Word running on a Macintosh system: Word 2004 I would like to test an Excel VBA app I made. Click on OK again to close out of the Word Options menu.

Click on either Disable All Macros With Notification or Disable All Macros With Notification to select it.Select the Trust Center option and click on the Trust Center Settings.Click on Office Button and select Word Options.Select the Security tab and click on the Macro Security button.Click on OK again to close out of the options menu.Click on either Medium or High to select it.Click on Tools, highlight Macro and click on Security.

Instructions for Word running on a Windows machine: Word 2000 To view instructions specific to the version of Word you are using click on one of the following links: (This occurs when the lowest level of security has been selected). This document explains how to enable macro protection in older versions of Office so that macros do not run automatically when a document is opened.

How to disable macros in excel 2000