Hi Wendy,

I suspect that this relates to your earlier post and that what you
really want to do is to prompt the user to select a row / record to
import from a 'source' workbook into the 'active' workbook.

The only way l can think of achieving this is to use the 'Window'
'Arrange' options, perhaps say placing the 'active' workbook on the
left and the 'source' workbook on the right with the window sized
smaller. This would achieve the visual impact required and allow the
row / record selection in the 'source' workbook.

Whilst writing l am thinking perhaps using the 'Window' 'Arrange'
'Cascade' option and resizing the 'source' window smaller may be a
visually better option. The 'source' window could open in the middle
of the 'active' window following a prompt to select the row / record.

If l am wrong in my original assumption and you only want to take a
'snapshot' of a particular sheet or sheet range look at the 'camera'
function. This will not provide any interactivity.

HTH

Regards

Michael