macro annoyance please help!

[johnny]

Hi all,

I have no macros at all in an Excel 2004 for Mac workbook. But
everytime I open the file I get the Macro warning asking if I want to
enable / disable Macros. This is really annoying. I am sure I have no
Macros because nothing appears whe I click tools->Macros. There are no
Macros to choose from.

How can I completely wipe this for my workbook so that I stop getting
annoyed by the warning?

Any help would be appreciated.

Cheers,

johnny

 

[J Laroche]

johnny wrote on 2005/04/28 19:17:

Hi all,

I have no macros at all in an Excel 2004 for Mac workbook. But
everytime I open the file I get the Macro warning asking if I want to
enable / disable Macros. This is really annoying. I am sure I have no
Macros because nothing appears whe I click tools->Macros. There are no
Macros to choose from.

How can I completely wipe this for my workbook so that I stop getting
annoyed by the warning?

Any help would be appreciated.

Cheers,

johnny

After opening the file, type alt-F11 to open the VBA editor. In the Projects
window, double-click on Sheet1, ThisWorkbook, and any other present. Their
code window will open. One of them may not be empty, which is causing the
warning. Erase the code. Close the editor by selecting Close and Return to
Microsoft Excel in the Excel menu.

Macros in the category Microsoft Excel Objects don't normally appear in
Tools / Macros.

JL
Mac OS X 10.3.9, Office v.X 10.1.6

 

[johnny]

Thanks! Turns out there were a couple lines of code lying around.
Problem fixed.

cheers,

J