in the vbe go to tools=References and see if you have a reference marked as
MISSING. If so, is it a reference to DAO? In any event, you need to
create a reference to DAO. It is possibly in a different location on this
machine.

--
Regards,
Tom Ogilvy

"Chris S" wrote in message
...
I have a user whose spreadsheet quit 'working'.
A button on the first worksheet executes a macro that uses several
declarations,
Dim ws As Workspace
Dim db As Database
Dim rs As Recordset

The Workspace, Database, and Recordset are all 'undefined.'
When I scan in the VBA Object Browser for 'Workspace' all I get is Excel
and
VBA
DAO doesn't show up.

We have another workbook that IS working. This one shows DAO in the Object
Browser.

Questions:
How do I get the DAO module BACK into the workbook??
HOW did this user eliminate it in the first place??
HOW do I keep her from doing it again?