>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

Hi Marcia:

Been mistaken many times. Thanks for the fill in. I just was not sure.

regards,