VBAPanel lists all macros from all files ever opened, they are not possible to remove

%3CLINGO-SUB%20id%3D%22lingo-sub-2004688%22%20slang%3D%22en-US%22%3EVBAPanel%20lists%20all%20macros%20from%20all%20files%20ever%20opened%2C%20they%20are%20not%20possible%20to%20remove%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2004688%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20is%20a%20bug%20in%20Excel%20(Office%20365%2C%20most%20recent%20version)%20wherein%20the%20Visual%20Basic%20for%20Applications%26nbsp%3Blists%20all%20macros%20from%20all%20files%20ever%20opened%2C%20they%20are%20not%20possible%20to%20remove.%3C%2FP%3E%3CP%3ESee%20the%20attachment%20for%20a%20screenshot%20showing%20multiple%20projects%20being%20listed%20in%20the%20panel%2C%20the%20files%20they%20are%20associated%20with%20are%20closed%2C%20they%20are%20not%20possible%20to%20remove%20as%20indicated%20by%20the%20greyed-out%20%22Remove%22%20context%20menu%20item.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssistance%20is%20appreciated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2004688%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2004908%22%20slang%3D%22en-US%22%3ERe%3A%20VBAPanel%20lists%20all%20macros%20from%20all%20files%20ever%20opened%2C%20they%20are%20not%20possible%20to%20remove%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2004908%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F907499%22%20target%3D%22_blank%22%3E%40__ivan__%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20a%20well-known%20bug%3B%20it%20occurs%20in%20older%20versions%20of%20Excel%20too.%20It%20is%20irritating%2C%20but%20not%20a%20show-stopper.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

There is a bug in Excel (Office 365, most recent version) wherein the Visual Basic for Applications lists all macros from all files ever opened, they are not possible to remove.

See the attachment for a screenshot showing multiple projects being listed in the panel, the files they are associated with are closed, they are not possible to remove as indicated by the greyed-out "Remove" context menu item.

 

Assistance is appreciated. 

1 Reply

@__ivan__ 

This is a well-known bug; it occurs in older versions of Excel too. It is irritating, but not a show-stopper.