cant find a macro
 

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

cant find a macro
 

Hi Smokii,

This is a common phenomenon.

See Debra Dalgleish's advice at:

http://www.contextures.com/xlfaqMac.html

---
Regards,
Norman



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

cant find a macro
 

Remove all of the modules. Check each sheet individually and especially
remember to check ThisWorkbook.
--
HTH...

Jim Thomlinson


" wrote:

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

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