What may cause macro modules to be created by accident?

H

herrdue

I understand how to remove macro modules, but I seem to have seen
numerous posts by other Excel users who question how macros could have
gotten into their workbooks to begin with; they say they didn't create
any macros, so why the warnings when they open the workbook. I'm
curious how this could happen accidentally. One reason I heard was
that modules could be created if users accidentally select "view code"
when right clicking on tabs. I tried to simulate this and no modules
were created, so I'm skeptcial. Certainly, if a user begins recording
a macro and then bails out, that would create a module. But do you of
you know of any additional ways users might end up with modules by
accident?
 
D

Dave Peterson

Check your other post.
I understand how to remove macro modules, but I seem to have seen
numerous posts by other Excel users who question how macros could have
gotten into their workbooks to begin with; they say they didn't create
any macros, so why the warnings when they open the workbook. I'm
curious how this could happen accidentally. One reason I heard was
that modules could be created if users accidentally select "view code"
when right clicking on tabs. I tried to simulate this and no modules
were created, so I'm skeptcial. Certainly, if a user begins recording
a macro and then bails out, that would create a module. But do you of
you know of any additional ways users might end up with modules by
accident?
 

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