It should just run, no magic, no secrets. Select the project in the VB
Editor, then go to the Tools menu and select References. Is anything listed
that begins with "MISSING:"? Perhaps even the Access library? If so, uncheck
it, and try again.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Melody" wrote in message
...
I did but it is still not working. I am not using a calendar. I keep
reading that this should run without Access but nobody says how. Are
there
options when installing Excel itself that need to be included, (or not
excluded)? It is being installed from the MS small business version as a
stand-alone component.

"Gord Dibben" wrote:

Did you see my reply Melody?


Gord Dibben MS Excel MVP

On Tue, 15 Jan 2008 05:56:03 -0800, Melody

wrote:

How? What exactly needs to be installed or how does Excel need to be
configured. What is wrong now that is causing this error?

"Gary''s Student" wrote:

Yes. Excel VBA can run without other Offfice products being
installed.
--
Gary''s Student - gsnu200765


"Melody" wrote:

I have a project that gets a "can't find project or library" error
when
running on a computer that does not have Access installed. Runs
fine on a
computer with Access. Tools/References is grayed out. Can VBA code
be made
to run without having Access installed?