'I .addPicture with OnAction like this:
With wsIF.Cells(rw, cl)
Set sh = wsIF.Shapes.AddPicture("D:
.jpg", msoCTrue, msoTrue, .Left, .Top + 1, -1, -1)
t = .Height
ion = "Item_Files_Icons_onAction
" 'drive a macro
, 1) = sh.Name 'to data
'With help from Rgonzo1971, (ref EE : Q_28580565.html ) an icon to expresses a screenTip like this:
t), Address:="", ScreenTip:="blabla"
'But when I add both screenTip and OnAction to the same sh, onAction only works in the absence of a screenTip.
It turns out that this true: http://www.spreadsheet1.com/screentips--onaction.html
and although this url points to a solution, I dont have the expertise to understand what the solution is.
The use of Ribbon ctls is not an option, as the icons must be used in an xl sheet, where I need to build my dashboard.
Could someone guide me to a workaround please?