Launch the
VB Editor (Alt-F11)
If the Project Explorer is not in view type Ctrl-R
Find the file in the Project Explorer
You should examine all Microsoft Excel Objects by typing F2, including
all Worksheets
ThisWorkbook
Chart sheets
If the ONLY code is Option Explicit at the top, that should not be treated
as a macro.
If there are userforms or modules, they are automatically regarded as
potential macros and trigger the security warning.
HTH
Bill Benson
http://www.xlcreations.com
wrote in message
oups.com...
I have a file that brings the macro warning dialog box at start.
However, after checking the macro list, and the code in VBA, nothing
appears to exist. Any suggestions how to find this missing macro?
Thanks.
Smokii