macro annoyance please help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

johnny - 29 Apr 2005 00:17 GMT

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

Reply to this Message

J Laroche - 29 Apr 2005 01:12 GMT

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

> Hi all,
>
[quoted text clipped - 12 lines]
>
> 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

Reply to this Message

johnny - 29 Apr 2005 23:32 GMT

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

cheers,

J

> 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
[quoted text clipped - 7 lines]
> JL
> Mac OS X 10.3.9, Office v.X 10.1.6

Reply to this Message

Mac Forum / Applications / Excel / April 2005

macro annoyance please help!