macro warning box
 

i have a spreadsheet that used to have a macro in it.
i've since deleted the macro, however the warning box
still comes up each time the spreadsheet is opened:

"spreadsheet.xls contains macros.

macros may contain viruses. etc.
disable enable more info"

when i go to the macro menu under tools, the macro is not
listed under spreadsheet.xls, this workbook or all open
workbooks.

macro warning box
 

Hi
there're probably some empty modules in your workbook. Try the
following:
- open the VBA editor
- delete/remove all (empty) modules
- check the worksheet modules and the workbook module
- cloese the VBA editor and save your workbook
- try again

--
Regards
Frank Kabel
Frankfurt, Germany


burke wrote:
i have a spreadsheet that used to have a macro in it.
i've since deleted the macro, however the warning box
still comes up each time the spreadsheet is opened:

"spreadsheet.xls contains macros.

macros may contain viruses. etc.
disable enable more info"

when i go to the macro menu under tools, the macro is not
listed under spreadsheet.xls, this workbook or all open
workbooks.

macro warning box
 

Danke, Frank

burke crosby
austin, texas


-----Original Message-----
Hi
there're probably some empty modules in your workbook.
Try the
following:
- open the VBA editor
- delete/remove all (empty) modules
- check the worksheet modules and the workbook module
- cloese the VBA editor and save your workbook
- try again

--
Regards
Frank Kabel
Frankfurt, Germany


burke wrote:
i have a spreadsheet that used to have a macro in it.
i've since deleted the macro, however the warning box
still comes up each time the spreadsheet is opened:

"spreadsheet.xls contains macros.

macros may contain viruses. etc.
disable enable more info"

when i go to the macro menu under tools, the macro is
not
listed under spreadsheet.xls, this workbook or all open
workbooks.
.