View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
William Benson[_2_] William Benson[_2_] is offline
external usenet poster
 
Posts: 230
Default cant find a macro

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