Excel Macros

[D T]

I am running Excel 2003 and when I start one of my worksheets I get a
message about the worksheet having macros. When I go to Tools Macros
there are none listed.

I did attempt to create a macro years ago, under Excel 97 but I could
never find it or use it.

How can I get rid of any macro remnent when it does not show in the
list of macros. The security message is a pain in the neck when I know
that there is no macro in existance

Thanks of any help

DJT

 

[Debra Dalgleish]

When you record a macro, Excel creates a module in which the code is
stored. When you delete the macro, the module is not automatically
deleted. There are instructions for finding and removing code on the
following page:

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

 

[D T]

Thanks for that. Just what I needed. It covered the problem exactly.

Thanks

DJT