Excel Project and Libraries

[Guest]

I have installed Excel XP working with add-ins such as FastExcel. I have one specific worksheet, which contains macros, which has a peculiar problem. Every time I edit the content of a cell I get the following message "Microsoft Vicual Basic - Can´t find project or library". When I press Ok to check the references, in "References - VBA Project", Excel does not indicate any problem with my Projects and Libraries - i.e. no MISSING message or project or library with a bad link - so I do not know how to fix it. I do not get this message with I do a CALC or a fill down for example. It is a great nuisance because instead of typing enter once to edit the content of the cell, I need to type it 3 times. Otherwise the worksheet works fine. I haven´t been able to find anything in Microsoft´s knowledge base. Anybody has any clue? Thank-you for your help. Best.

 

[Charles Williams]

Hi Marcos,

when you check references you only see the references for the currently
active project, so make sure that you have selected the project that
contains the macros for that specific worksheet.
(or check all the projects one by one).

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

I have installed Excel XP working with add-ins such as FastExcel. I have

one specific worksheet, which contains macros, which has a peculiar problem.
Every time I edit the content of a cell I get the following message
"Microsoft Vicual Basic - Can´t find project or library". When I press Ok to
check the references, in "References - VBA Project", Excel does not indicate
any problem with my Projects and Libraries - i.e. no MISSING message or
project or library with a bad link - so I do not know how to fix it. I do
not get this message with I do a CALC or a fill down for example. It is a
great nuisance because instead of typing enter once to edit the content of
the cell, I need to type it 3 times. Otherwise the worksheet works fine. I
haven´t been able to find anything in Microsoft´s knowledge base. Anybody
has any clue? Thank-you for your help. Best.