I DO dynamically display and delete SHAPES (derived from .jpgs) on an excel sheet.
Set Sh = ws.Shapes.AddPicture("C:\p
.jpg", msoCTrue, msoTrue, .Left, .Top, 20, 16)
The shapes DO actuate subs via hyperlinks;
Hyperlink ScreenTips provide users with a tooltip explanation for the informational role of each shape.
I WISH to have comments on various cells in the same xl sheet to explain other data, which is not associated with the hyperlinked shapes.
HOWEVER, as the attached demo shows (one sub of v few lines):
When I add a cell COMMENT, this causes a runtime error in the sub at the level of adding the hyperlink to the SHAPE. this occurs even when all the arguments are null:
s.Count), Address:="", SubAddress:="", ScreenTip:=""
Comments on sheet2 do not cause runtime errors to shapes added to sheet1.
This looks like a bug?
Have anyone got a work-around or other suggestion?