Please Help, Excel VBA

[Sforster]

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

[paulw]

Steve,

I would try and help but it seems that my grasp exceeds my reach with Excel (i.e. I cock it up), but keep asking the questions, 'cos I'm learning...

Cheers,

P.