Thread: How do I get focus back on an Excel file?

When automating Excel, if there is a picture (graphic) on the worksheet, when
the file is opened, the picture has the focus and mouse-clicks anywhere on
the Excel window are lost. Is there a way to get the focus back so that
other cells can be editted?

Insert this line of code into the macro:

ActiveSheet.Range("A1").Select

You could also rework the code to avoid selecting the shape in the first
place.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Stumpiana" <Stumpiana@discussions.microsoft.com> wrote in message
news:556F2829-7E22-4B37-9D25-CD1742D1052C@microsoft.com...
> When automating Excel, if there is a picture (graphic) on the worksheet,
> when
> the file is opened, the picture has the focus and mouse-clicks anywhere on
> the Excel window are lost. Is there a way to get the focus back so that
> other cells can be editted?