Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why am I getting 2nd macro security warning? | Excel Discussion (Misc queries) | |||
Macro Warning | New Users to Excel | |||
Macro warning box | Excel Discussion (Misc queries) | |||
macro warning | New Users to Excel | |||
Redundant Macro warning or hidden macro? | Excel Programming |