macro warning box

B

burke

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.
 
F

Frank Kabel

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
 
B

burke

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


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top