ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I get focus back on an Excel file? (https://www.excelbanter.com/excel-programming/345881-how-do-i-get-focus-back-excel-file.html)

Stumpiana

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?

Bob Phillips[_6_]

How do I get focus back on an Excel file?
 
Try activating a cell, such

Activesheet.Range("A1").Select

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stumpiana" wrote in message
...
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?




Stumpiana

How do I get focus back on an Excel file?
 
This worked! Thank you!!

"Stumpiana" wrote:

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?



All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com