How many are checked now <shudder

There shouldn't be more than 5 checked (of course which 5 would be
important).

--
Regards,
Tom Ogilvy


" wrote
in message ...
OK, now it works. There were no "missing" entries. Only the first five
options were checked however. Thank you for your help.

"Norman Jones" wrote:

Hi Jim,

The References Option is greyed out and I am unable to select it.

This would happen if you are in break mode - press the macro reset
button
and then try Bob's suggestion.


---
Regards,
Norman



"Jim Mooney" <Jim wrote in message
...
The References Option is greyed out and I am unable to select it.

"Bob Phillips" wrote:

Jim,

Try going into ToolsReferences in the VBE, and see if there is a
Missing
reference in the list. If there is, uncheck it. You may need to
browse
for
the correct version to ensure that things still work.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jim Mooney" wrote in message
...
I don't know why Trim(...) function does not work in the
Excel programming section of a worksheet for Excel 97. I
also have a copy of Office 2003 and it works fine with
this version.

How do I convert this statement in Office 2003:

Name = Trim(Name)

to work in Office97? The error keeps coming up:

Can't find project or library

Trim is highlighted.