I have two macros in excel vba. One reference the other to crate dynamic menus (i.e.: the macro that creates the menu has permission for access to VBA Project). We intermittently get the message "This workbook is currently referenced by another workbook and cannot be closed when excel is started. Once it occurs, it stays.
I have included "On error resume next" and "applications.displayalerts = false" code in auto_open in both macros. All seems fine until windows performs an update. I do not know if the update has anything to do with this , but it seems to possibly have some correlation.
I can resolve the issue by re-establishing the reference between the macros. However the macros are deployed as packages to customers in large enterprises and therefore that manual solution is not feasible..
Any idea as to how to prevent this message from showing -- permantly?