Hi,

I wonder if anyone can answer this !!

I am updating a formula within a cell in (Lets say) Workbook 1, the formula is a link to another workbook (Lets say) Workbook 2. The trouble is that I would like to give the user a list of the available sheets within workbook 2 without opening it....

I know this is possible because if I change the formula within workbook 1 and it's not a worksheet within workbook 2 then a dialog box pops up with all the worksheets in workbook 2.

My question is does anybody know how to call the dialog box so that I can at any time show it so that the user can select a particular sheet.

I hope that I have explained it well !!!!

Cheers for any help

Steve