View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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.