Code to fix: 'can't find project or library'

I have a problem where the end-users of my spreadsheet are receiving this
error when executing a Worksheet_Change procedure [Format(...)]. From what I
read, the users need to clear any 'Missing' References.
My question is, can code be put into (where?) a spreadsheet to automatically
clear the Missing References or at least sidestep the problem? Anyone have
code out there?

But sometimes the reference is critical to the operation of the macro. This
must be corrected. For example, I recently dealt with a bizarre situation
where the machine was running Excel 2000 (Office 9), but in the Add-Ins list,
the reference to the ATP pointed to a file in the directory for Office 2003
(Office 11). This directory didn't exist. We had to do a Detect and Repair on
the Excel installation.


On Fri, 25 Mar 2005 08:57:03 -0800, EWR <[email protected]> wrote:

>I have a problem where the end-users of my spreadsheet are receiving this
>error when executing a Worksheet_Change procedure [Format(...)]. From what I
>read, the users need to clear any 'Missing' References.
>My question is, can code be put into (where?) a spreadsheet to automatically
>clear the Missing References or at least sidestep the problem? Anyone have
>code out there?

PS: You might want to investigate whether a commercially available Installer
program like Install Shield, etc, can handle this.

On Fri, 25 Mar 2005 08:57:03 -0800, EWR <[email protected]> wrote:

>I have a problem where the end-users of my spreadsheet are receiving this
>error when executing a Worksheet_Change procedure [Format(...)]. From what I
>read, the users need to clear any 'Missing' References.
>My question is, can code be put into (where?) a spreadsheet to automatically
>clear the Missing References or at least sidestep the problem? Anyone have
>code out there?