False macro indication

  • Thread starter Thread starter Graham Hill
  • Start date Start date
G

Graham Hill

Help
When I open Excel I get the following message (in quotations below). The
only way to actually open the sheet is to disable the macro. The problem is
I have not run nor created a macro. I did look at the macro function not
really understanding it but as far as I know I didn't record anything. There
is no listed macro. Also, since I have had this problem it (or something)
seems to add on 15 -20 seconds before I am able to open a web site on the
internet. How do I get rid of this message? Thanks for any help.

Graham Hill


"documents.xls contains macros.

Macros may contain viruses. It is always safe to disable macros, but if the
macros are legitimate, you might lose some functionality.
- Disable Macros
- Enable Macros
- More Info"
 
Hi Graham
try the following
- open the workbook with macros enabled
- open the VBA editor
- delete all modules (although they're probably empty)
- also check the worksheet modules and the workbook module for rests of
old code
- close the VBA editor
- save and close your workbook and try again
 
Hi Graham

With the Workbook open push Alt+F11 and then select any macros from the
"Project Explorer" (Ctrl+R) and right click and select "Remove <Module
Name>" and say "No" when asked to Export.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
When you record a macro, Excel creates a module in which the code is
stored. When you delete the macro, the module is not automatically
deleted. There are instructions for finding and removing code on the
following page, and a link to Chip Pearson's macro to remove all VBA
code in a workbook:

http://www.contextures.com/xlfaqMac.html#NoMacros
 
Back
Top