Workspace faux user-defined type not defined
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?
|