Cannot find macro

N

New users

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?
 
G

gls858

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?
See the messages with subject, macro warning. They solved this problem
for me just yesterday.

gls858
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top