Excel workbook will not close due to VB Reference link

[Guest]

My VB modules seem to remain in memory, even after the workbook containing
them has been closed. Open workbooks which had been referenced in VB by a
closed workbook cannot be closed, without shutting down Excel itself. Often
this leads to an error. Any suggestions, please.

 

[vidi]

My VB modules seem to remain in memory, even after the workbook containing
them has been closed. Open workbooks which had been referenced in VB by a
closed workbook cannot be closed, without shutting down Excel itself. Often
this leads to an error. Any suggestions, please.

Don't Write Modul in Personal.xls
instead use one File excel to keep all macros (for e.g macroserver).
and then other files you can use command 'application.run' pointting to
macroserver'

maybe this can help.

 

[Tom Ogilvy]

This can be caused by Google Desktop/Search being installed

http://www.dicks-blog.com/archives/2004/12/11/google-desktop/