Focus on a picture

[Scientific]

Hello all,

Last ? for today, I promise.

I have a picture in cell A1 and I want the focus to be on the picture, not
the cell it occupies when the workbook opens. Is this possible?

-S

 

[Scientific]

I figured out how to do this with the following code:

Sub Workbook_Open()
Set myDocument = Worksheets(1)
myDocument.Shapes("Picture 1").Select
End Sub

I had to first give a name to the picture from Insert Menu:

<Insert> <Name> <Define>

-S

 

[Dave Peterson]

You want the picture selected when the workbook is opened?

Option Explicit
Sub Auto_Open()
With Worksheets("Sheet1")
Application.Goto .Range("a1"), scroll:=True
.Pictures("picture 1").Select
End With
End Sub

Change the name of the sheet and the name of the picture.

 

[Scientific]

Dave,

Many thanks to you for your help on this. It works great and I'm very
grateful for your contribution. Keep up the good work my friend

-S