Can you really select a cell in another workbook with the input box? I didn't think that was possible.
Presumably if you can select a cell, the cell you've selected is already in the activeworkbook...
If for some reason that's not true, this would work in a pinch
There's parent properties but I've never had much luck with them. Maybe someone else here can show the way... Regards.Code:Dim wb as workbook Set wb = ActiveWorkbook AAA.Select msgbox ActiveWorkbook.FullPath wb.Select