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

David,

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



"David Weilmuenster" wrote in message
...
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

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

David


-----Original Message-----
David,

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



"David Weilmuenster" wrote in
message
...
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


.

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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mohsinb" wrote
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.

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.

--
Regards,
Tom Ogilvy



mohsinb wrote in message
...
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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/