How to prevent Moduls to be automatically added when switching from Excel do VBA Editor with <Alt>F11

Jürgen Brändle 0 Reputation points
2024-03-17T14:28:46.34+00:00

Hello

When opening Excel and switching from Excel to VBA Editor with <Alt> F11 the following happens:

PC 1: A Module is automatically added to the active workbook

560fb1ee-e036-4133-b593-1d91125fa686

PC 2 and PC 3: Nothing happens

f5d21267-5f5e-4684-963c-3cb7fac33789

Why does this happen and how can the automatic addition of a module be prevented?

PC 1 and PC 2: W10 Pro 22H2

PC 3 : W11 Home 23H2

On all PC's Microsoft® Excel® für Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 32 Bit

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,596 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,636 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,669 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,451 Reputation points
    2024-03-18T06:42:21.2866667+00:00

    Sure it's "added" and do not already exists in the default template?

    0 comments No comments

  2. Jürgen Brändle 0 Reputation points
    2024-03-18T09:42:38.0233333+00:00

    No, it does not exist in the default template

    0 comments No comments