Cannot find macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
Click to expand...
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 tools>macro>mocro 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 file>remove module. it will ask if you want to save
the contents, click no.
repeat for all modules.
 
Back
Top