Question: What is needed for the contents of Module1 to be availble to other modules in a VBA project, but not to any other VBA project?

  1. Set Option Global at the top of Module1
  2. Declare module-level variables as Private
  3. Set Module Level Scope at the top of Module1
  4. Set Option Private Module at the top of Module1

Answer: The correct answer of the above question is Option D:Set Option Private Module at the top of Module1