| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get focus back on an Excel file? | Charts and Charting in Excel | |||
| How do I switch focus from a modeless user form back to the excel. | Excel Programming | |||
| Change focus from Userform back to Sheet | Excel Programming | |||
| Focus back from modeless userform to sheet | Excel Programming | |||
| Must be a way to force focus back to sheet instead of UserForm - isn't there? | Excel Programming | |||
Linear Mode
