Hidden Macro

R

Remington

I have a excel file that was converted from Excel 97 to 03. At first
was getting an error, but fixed it by removing hidden names. Now I a
still getting a security warning saying there is a macro in the file
but none show up on the macro list and there were no macros on it t
begin with. Any ideas on how to remove this hidden macro? Thank
 
T

T Kirtley

The security warning means that there is a module in the workbook, even if
there is no code in the module. If you press Alt^F11 the VB editor will open,
and the project explorer will list all open workbooks and the objects and
modules they contain. If you remove the module for the workbook in question
the security warning should not come up any more.

TK
 
Top