Enable Macros... Question

[Guy Kudlemyer]

Hello:

I have an Excel spreadsheet that has NO MACROS in it. Yet, each time I open
it, I'm presented with a dialog box that asks if I want to Enable or Disable
Macros.

How do I tell Excel that there are NO MACROS once and for all? Or, if there
was inadvertently a Macro installed, how do I hunt it down and nuke it so
that I'm not assaulted by this dialog box anymore?

Any help will be appreciated!

--Guy
Thurston, OR

 

[Bob Greenblatt]

Hello:

I have an Excel spreadsheet that has NO MACROS in it. Yet, each time I open
it, I'm presented with a dialog box that asks if I want to Enable or Disable
Macros.

How do I tell Excel that there are NO MACROS once and for all? Or, if there
was inadvertently a Macro installed, how do I hunt it down and nuke it so
that I'm not assaulted by this dialog box anymore?

Any help will be appreciated!

--Guy
Thurston, OR

I've seen this message when workbooks originally created in the windows
environment and containing active-x controls were moved to the Mac. Even
though the controls were removed, the macro warning persists. If this is the
case, the the workbook is corrupt (even though it apparently works properly
in other respects.) You may be able to "decorrupt" it by saving the
worksheets individually to a new workbook.

If there are indeed macros, and a single space character in a module will
count as a macro, you can delete them by:
1) Going to the visual Basic Editor by option-F11
2) See if any modules are present. If so remove them by right clicking on
the module in the explorer window
3) For each Excel object, double click to expose the object's code page,
then make sure there is nothing there.
4) Click on the Excel icon in the upper left to return to Excel, save, close
and reopen the workbook.

 

[Guy Kudlemyer]

Bob:

I've seen this message when workbooks originally created in the windows
environment and containing active-x controls were moved to the Mac. Even
though the controls were removed, the macro warning persists. If this is the
case, the the workbook is corrupt (even though it apparently works properly
in other respects.) You may be able to "decorrupt" it by saving the
worksheets individually to a new workbook.

If there are indeed macros, and a single space character in a module will
count as a macro, you can delete them by:
1) Going to the visual Basic Editor by option-F11
2) See if any modules are present. If so remove them by right clicking on
the module in the explorer window
3) For each Excel object, double click to expose the object's code page,
then make sure there is nothing there.
4) Click on the Excel icon in the upper left to return to Excel, save, close
and reopen the workbook.

Although I'm not all that technically savvy, I think I basically understood
what you wrote (above), and I gave it a reasonably decent shot. I found no
modules; thus, nothing to remove. (Just to be sure, I inserted a module just
to see what it was, then I deleted it after I found nothing similar.)

I was hoping to just find a "Remove all Macros" button somewhere in one of
the menus. However, I cannot. Does that kind of thing exist?

Thanks again for your help!

--Guy
Thurston, OR

 

[CyberTaz]

Perhaps a more direct but less complex route, although there is no 'Remove
All Macros' button -
In the wkbk of concern go to Tools>Macro>Macros, pop open the list of Macros
In: & choose This Workbook (just to be on the safe side). Any Macros in the
file _should_ be listed, which you can then select & delete from there.
Based on Bob G's method I don't know if there might be 'hidden' stuff that
may not show up in that list, but if the Macro dialog doesn't resolve the
issue I'm certain he will have further input for you.

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