HELP!! Removing macros that have shown up automatically

[swimzip]

Hi,
I have a problem: I created an Excel spreadsheet on my Mac OS X
system. The spreadsheet contains no macros (I don't even know how to
impliment them). When I opened the file there was an error message
that said Macros have been detected in the workbook what do you want to
do? enable macros, don't open, or disable macros. So I tried to open
the file with the macros disabled and while I was working with some of
the formulas, a macro error showed up again.

I've tried opening tools > Macros > Macros, but there is nothing in
there. I've also tried using alt+F11, but there are no macros in the
visual basic editor, just worksheets and a workbook, no modules. Any
advice would be great!!

Thanks!
-Robby Stout

 

[CyberTaz]

The warning is a little misleading because it can be triggered by a number
of things other than macros... Customized toolbars, menus & kybd shortcuts
for example. The feature is intended to protect against macro viruses, but
can be disabled if you wish in Excel>Preferences>Security - remove the 'Warn
before...' check.

Especially if you exchange XL files with PC users I'd recommend leaving the
feature active. As long as the file is from a 'trusted source' click the
enable button when the dialog appears.

You might also wait for a response from others - I was under the impression
that the notice *shouldn't* be triggered if you open a file you created
yourself (same user, same system) regardless of macros or customizations.
Unless there is more to the story than you've shared about the file there
may be other issues involved.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Bob Greenblatt]

I've seen this warning when there are no apparent macros. For example, a
blank XLM macro sheet, or a single space character in a module will generate
this message. Your original post stated that you got a macro error when you
opened the workbook with disabled macros. That sounds to me like there
really are macros. You said there were no modules, but did you check the
individual worksheets and ThisWorkbook code pages? There might also be a
defined name that referred to another workbook that did contain macros.

 

[swimzip]

Thanks to the both of you for your help, I was able to find and delete
the macro (I'm not sure what it did, but I'm sure I'm better off
without it --> it looked like a converter). The solution was:

Opening the worksheet with the macros enabled.
Opening the editor by pressing Alt+F11.
Double clicking on each of the sheets until the macro was found, and
simply deleting it and saving.

Thanks again!
-Robby Stout