Hi James.

>> But I don't think grids show up in active control, just the textboxes etc in the grid. So you will have to check the grandparent of the activecontrol to see if it is a grid. Its been a while since I looked at this code, so I may be wrong about activecontrol not showing grids. <<

You are mistaken. It is possible for the activeControl to be a grid. You may be thinking of the problem that occurs if a grid is the activeControl when you click on a toolbar button. In that case, if you want to update the controlsource of the activeControl, you have to drill down into it to find the active cell.

Marcia