View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
herrdue herrdue is offline
external usenet poster
 
Posts: 2
Default What may cause macro modules to be created by accident?

I've seen numerous posts here about how to resolve nagging macro
warnings in workbooks where the user claims there are no macros. I
understand how to erradicate them. However, I'm curious as to what
this group believes are the reasons as to why these modules are
created in the first place. I saw in one post, someone suggested it
could happen after right clicking on a spreadsheet tab and selecting
"view code" by accident. Yet, if I try that, no modules are created,
so I can't see how that would be the culprit. Another explanation
would be if someone went so far as to begin recording a macro by
accident and then promptly bailing out, and yes, I can see how that
would generate a module. But it seems many foks feel these macros can
appear without these types of activities. Are there any other actions
that might cause unwanted modules to appear...things to caution users
about during training? Thanks in advance for your input.