Open a menu

[Greg B]

Hi,
I am wondering the code to open up the menu option of insert a picture from
scanner or camera.

Thanks
Greg

 

[Tom Ogilvy]

If you actually want to show the menu as you state:

Sub aAA()
'1764
Application.CommandBars.FindControl(ID:=1764).Execute
End Sub

 

[Joel]

I recorded a macro and then read a picture. this is the code

ActiveSheet.Pictures.Insert("C:\TEMP\Brooklyn bridge 1.jpg").Select