Cannot find macro
 

I was alerted when I was opening an excel sheet that there were macros. The
file was originally created by another person. However, when I went in and
tried to delete them, I did not see any macro listed. Where can I find these
macros?

New users wrote:
I was alerted when I was opening an excel sheet that there were macros. The
file was originally created by another person. However, when I went in and
tried to delete them, I did not see any macro listed. Where can I find these
macros?
See the messages with subject, macro warning. They solved this problem
for me just yesterday.

gls858

hi,
if you don't see any macro in the toolsmacromocro box
chances are that there are no macros but the modules that
used to house the macros are still there and that is what
is causing the message.
open the vb editor (alt+f11)
on the left click the + by your project name(file name) to
expand the tree.
if you see any modules, double click it. if it is empty
click fileremove module. it will ask if you want to save
the contents, click no.
repeat for all modules.

-----Original Message-----
I was alerted when I was opening an excel sheet that
there were macros. The
file was originally created by another person. However,
when I went in and
tried to delete them, I did not see any macro listed.
Where can I find these
macros?
.