Bogus Excel 2002 Macro Security Message

[David Weilmuenster]

In an Excel 2002 worksheet I had recorded a simple macro
to rearrange some data. After completing that work, I
deleted the macro.

There were never any other macros in the worksheet.

Now, whenever I open the worksheet, I get a message that
says ".... contains macros. Macros may contain
viruses. ..." where .... is the name of the worksheet.
It then forces me to disable or enable macros.

If I turn security to high, this message doesn't appear,
of course. But it appears every time, if macro security
is medium.

But there's no macro in the worksheet, and no other
worksheets are open.

How can I convince Excel 2002 that there are no macros in
this worksheet?

Thanks,
David

 

[Chip Pearson]

David,

You need to remove the module(s) in which the macros were stored.

 

[Gord Dibben]

David

With your workbook open....

ALT + F11 to get to VBE

Select your workbook/project and expand with + sign. You will see a "Module1"
or similar.

Right-click and select "Remove Module".

Excel believes a module has code even when it does not.

Gord Dibben XL2002

 

[Guest]

Thanks, that solved it. Silly me for assuming that
deleting the macros from Excel, not VBA, actually deleted
them.

David

 

[mohsinb]

Hello,

I have deleted all modules in VBE, and I see a clean slate but I am
still getting the macro -enable - disable box. When I click disable
then I get the message "Workbook contains a type of macro (Microsoft
excel version 4.0 macro) that cannot be disabled. There may be viruses
in these macros".

I have been dabbling with Excel progamming since last 2 weeks using
office 97. I have no clue where I might be using Excel 4.0 macros in my
code. I need help in identifying these macros before I can go about
fixing them.

Thanks in advance.

 

[David McRitchie]

You do have to delete the entire modules, but code may also reside
with the sheets in the project (workbook).

Individual sheets may contain code, you don't want to delete the
sheets in the VBE, but you do want to delete any code inside. There
is also ThisWorkBook. Chip Pearson has a macro in his
Coding for the Visual Basic Editor
http://www.cpearson.com/excel/vbe.htm

 

[Tom Ogilvy]

Did you insert a macro sheet?

Do you have defined names (insert=>name=>define). (names can be hidden
however).

Did you use the Data Tracking addin - I think it puts in a hidden macro
sheet.