Cheryl,

Haven't tried it myself, but Tom Ogilvy recently posted these links that
mighte help you.

http://support.microsoft.com/default...29&Product=xlw
XL2000: How to Programmatically Create a Reference

http://support.microsoft.com/default...47&Product=xlw
XL97: How to Programmatically Create a Reference

You only need to create a reference to the extensibility library so you can
see it in the object browser.

By the way, Cheryl, Gareth?


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Gareth" wrote in message
...
both references are needed in the '97 file.

the users would not be up to the task of changing the reference.

is there any way (by code) to reset them?

Cheryl