-
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
-
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...:D
Cheers,
P.
