VBA project remain open in VBA Editor when I close the workbook (Excel)

Question

VBA project remain open in VBA Editor when I close the workbook (Excel)

Ker9 10

Recent move to Office 365, problem seems to be happening across entire company.

Any workbooks (with or without macros) that are opened and then closed remain open and visible in the VBA project editor. If you open it again, then you have 2 instances, etc.

Workbooks are on hard drive (not SharePoint or OneDrive).

Exit Excel and once open again the problem is cleared. After some period of time, it seems you must reboot to clear the issues - appears to hog memory.

Does NOT occur in Word, only Excel.

I disabled ALL add-ins, no change.
I do not have Google drive running.
Removed Data Streamer, no change.
Removed Acrobat, no change.

All file locations in setup point to hard drive.

I am aware this is an old problem without a solution. I had this problem some years ago and removing Adobe Acrobat .COM seemed to work, but not this time.

Michel St-Louis 0

I possibly have a case that can reproduce this problem:
- I open a workbook 1 and assigne one of its function (a menu) to a key (through OnKey)
- I open a workbook 2.
- workbook 2 calls the onkey function.
- The caller (workbook 2) selects to close all the workbooks(except WB 1):
   the workbook 2 closes, but the project keeps an entry for workbook 2.
That happened to me more than once (not sure if it is always in the same context), but just found out that context could be my problem.
Could be an investigation avenue for those with the problem...
I did not check if it happens every time, and neither search yet for a way to prevent this...

2 answers

Your answer

Michel St-Louis 0 Reputation points

2023-08-16T07:30:56.66+00:00

I possibly have a case that can reproduce this problem: - I open a workbook 1 and assigne one of its function (a menu) to a key (through OnKey) - I open a workbook 2. - workbook 2 calls the onkey function. - The caller (workbook 2) selects to close all the workbooks(except WB 1): the workbook 2 closes, but the project keeps an entry for workbook 2. That happened to me more than once (not sure if it is always in the same context), but just found out that context could be my problem. Could be an investigation avenue for those with the problem... I did not check if it happens every time, and neither search yet for a way to prevent this...

Answer 1

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 2

Hi,

I think I have seen this issue being faced by others in the past.

Here are some steps you can try to troubleshoot the issue-

To make sure that all of the Excel components are operating properly, repair your Office 365 installation.
Despite the fact that you said to disable all add-ins, it's still important to check for any COM add-ins that might be causing issues. To disable any listed add-ins, navigate to File > Options > Add-Ins, select "Manage," then click "Go..." to the "COM Add-ins" section.
In addition to COM add-ins, look for any third-party add-ins that might be the source of the issue. Even if an add-in is not listed in the Excel Add-ins dialogue box, conflicts may still arise. Remove any add-ins from third parties for the moment and check if the problem still exists.
Search the Windows Event Viewer for any associated error messages or events that could provide more information about the problem.
Check for any pending Office updates and install them.
Make sure your graphics card drivers are up to date because corrupted or old drivers can occasionally cause Excel problems.

Best Regards.

Share via

VBA project remain open in VBA Editor when I close the workbook (Excel)

2 answers

Your answer