Hidden Macro

  • Thread starter Thread starter Remington
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros security 2
Running macros with protect workbooks 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Macro & Protected sheet 2
upgrade macros to 07 7
Hidden Characters? 2
problem with macros and protections 5
Can't find macro in an Excel file to delete it 3

Back
Top