Renaming sheet and workbook CODENAMES - unexpected addition of objects in the project?

  • While testing some stuff for a project I'm working on, I wanted to see if I can change the codenames of sheets and workbook objects in the VBA project (after activating the "Trust access to VBA Project" setting.

    I noticed that renaming the codename of a sheet works nicely, however when renaming the codename of the active workbook it basically creates ADDITIONAL WORKBOOK OBJECTS in the object browser in VBE each time I run that ... (see screenshot in attachment). This seems to happen on both Mac and Windows versions of Office 365.

    Any idea's on why this happens and how it can be avoided? (note that I only tested this on the "Active Workbook"...)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!