Excel says macro, but no macros present?
 

I have a certain excel file that I use daily, and everytime I open this
file it gives the old "This file contains macros - do you want to
enable them or not?" warning. However, as far as I know, the file
doesn't contain any macros. There's nothing listed in Tools - Macros.
There are no modules. No unusual add-ins. And no unusual references.
I only have this problem with this single file, and no others. Virus
scan turns up nothing. Any ideas?


--
Pho
------------------------------------------------------------------------
Pho's Profile: http://www.excelforum.com/member.php...o&userid=28815
View this thread: http://www.excelforum.com/showthread...hreadid=485060

Excel says macro, but no macros present?
 

Delete empty modules
--
Gary's Student


"Pho" wrote:


I have a certain excel file that I use daily, and everytime I open this
file it gives the old "This file contains macros - do you want to
enable them or not?" warning. However, as far as I know, the file
doesn't contain any macros. There's nothing listed in Tools - Macros.
There are no modules. No unusual add-ins. And no unusual references.
I only have this problem with this single file, and no others. Virus
scan turns up nothing. Any ideas?


--
Pho
------------------------------------------------------------------------
Pho's Profile: http://www.excelforum.com/member.php...o&userid=28815
View this thread: http://www.excelforum.com/showthread...hreadid=485060

Excel says macro, but no macros present?
 

Debra Dalgleish has some instructions:
http://www.contextures.com/xlfaqMac.html#NoMacros

Pho wrote:

I have a certain excel file that I use daily, and everytime I open this
file it gives the old "This file contains macros - do you want to
enable them or not?" warning. However, as far as I know, the file
doesn't contain any macros. There's nothing listed in Tools - Macros.
There are no modules. No unusual add-ins. And no unusual references.
I only have this problem with this single file, and no others. Virus
scan turns up nothing. Any ideas?

--
Pho
------------------------------------------------------------------------
Pho's Profile: http://www.excelforum.com/member.php...o&userid=28815
View this thread: http://www.excelforum.com/showthread...hreadid=485060

--

Dave Peterson