Importing to drop down list from another workbook

[Keith24249]

Hi,
I have created a quoting worksheet and I want to populate the drop down boxes in certain cells with data in another workbook. I have been on the contextures website and followed the instuctions but keep getting an error message stating that the selected range cannot be found. I can get it to work with the data list in the same workbook but as the quote worksheet is going to be emailed to clients I don't want the sensitive data going with the quote worksheet. Another option would be to only email the quote worksheet without all the other worksheets, is that a possibility.
Many thanks
Keith

 

[VoG]

I think that mailing just the quote sheet would be the simplest option. You should find some suitable code here http://www.rondebruin.nl/sendmail.htm

 

[Keith24249]

Many thanks for this link, the code contained therein works like a charm
Regards
Keith