ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hidden Macro (https://www.excelbanter.com/excel-discussion-misc-queries/93172-hidden-macro.html)

Remington

Hidden Macro
 

I have a excel file that was converted from Excel 97 to 03. At first I
was getting an error, but fixed it by removing hidden names. Now I am
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 to
begin with. Any ideas on how to remove this hidden macro? Thanks


--
Remington
------------------------------------------------------------------------
Remington's Profile: http://www.excelforum.com/member.php...o&userid=35268
View this thread: http://www.excelforum.com/showthread...hreadid=550430


T Kirtley

Hidden Macro
 
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

"Remington" wrote:


I have a excel file that was converted from Excel 97 to 03. At first I
was getting an error, but fixed it by removing hidden names. Now I am
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 to
begin with. Any ideas on how to remove this hidden macro? Thanks


--
Remington
------------------------------------------------------------------------
Remington's Profile: http://www.excelforum.com/member.php...o&userid=35268
View this thread: http://www.excelforum.com/showthread...hreadid=550430



Remington

Hidden Macro
 

That was it, thanks alot.


--
Remington
------------------------------------------------------------------------
Remington's Profile: http://www.excelforum.com/member.php...o&userid=35268
View this thread: http://www.excelforum.com/showthread...hreadid=550430



All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com