I downloaded this sheet
viewtopic.php?f=8&t=4659 and added the code to my existing excel sheet. As soon as I try and connect the Workbook now, it won't reveal or recognise the Worksheet that Gary's code resides on (Sheet 1). As soon as I remove it, everything's good again. Sure I could live without it, but it seems like a beneficial addition. Any ideas?
Cheers