Have you checked to see that xla workbook has been selected as an add-in (in
tools menu)?

Yes in the Sheets... and tried to in the VBE but I don't see it there.

I don't think I have explained myself properly.

You have to save workbook 1 as an xla file. Then from within Excel itself (not
VBA) go to Tools, Add-Ins, Browse for the file workbook 1, select it and it
should then show up with a tick beside it in your list of Add-Ins. The macro
code within it will then be available for use in workbook 2.

Hope this is clearer?

I think I've got it now. I was probably too vague in my description. I
wanted to use code  in workbook 1 from *code* in workbook 2.

I found a great web page that gave me the solution.... I wasn't adding
the XLA to the References in the VBE.

http://www.fontstuff.com/vba/vbatut08.htm

Thanks for your help... you prompted me to put "reference" in the
google search!

Not something I've ever tried - so I wouldn't have been able to help - but if I
do ever try at least I'll have the answer!