Is there a way to have VBA check to see if there is a reference and, if not, set it on an
open event?

I need to set a reference to the "Microsoft Shell Controls and Automation" object if it's
not already set.
(it will save me having to guide someone over the phone-albeit not a long trip!)

xl2kPro
--
Regards;
Rob
------------------------------------------------------------------------