References are carried in workbooks. So whatever workbook originated the
document, it contained a reference to the control. You don't have to use the
control for someone to create a reference to it.

--
Regards,
Tom Ogilvy


"Kieran H" wrote:

On Feb 2, 3:58 pm, Tom Ogilvy
wrote:
go to the versions that have the reference and remove it or distribute a new
version where the reference has been removed.

--
Regards,
Tom Ogilvy



"Kieran H" wrote:
To those who Excel!

I have an xlt that has been working faultlessly for many months. Alas
it it starting to fail for certan users where the cause is a missing
ref.

This in itself ought to be straightforward except that it is looking
for :

Missing Microsoft RichTextbox Control 6.0 (SP3) This is curious as
this control is not included in the template.

In the instances where there is no problem this reference is not
listed at all -

I am using Excel 2000 - The failure sympton is the predictable
rejection of Right, Left or Trim

The template connects to a SQL server database (ODBC) and serially
calls some SPs to populate tables and graphs.

I realise this is light on detail but I ask in the hope that it rings
bells as is.

Cheers

Kieran- Hide quoted text -

- Show quoted text -


Tom,

My thanks,

Alas the document that the template produces is distributed wider that
I would have easy access to. It only contains a procedure to print
all pages and a procedure to check the locale so that it can correctly
determine the page size.

My reason for posting is that I am baffled that a Missing Ref can
exist for a control that I am not using.

The only unusual item is that I reference the VBE in order to remove
modules that I do not want to be distributed unecessarrily