Solved

excel image in graphic file is displayed on worksheet: how to disable details of graphic's file path in tooltip info?

Posted on 2014-11-10
5
85 Views
Last Modified: 2014-11-11
- I import a graphic (eg .jpg) into a worksheet cell. It displays well.
- I point the cursor at the graphic; however...
- The directory path to the graphic file is displayed over the worksheet in a tooltip message.
- (eg: D:\aaThink_Build\Thk_Building\xlImages..)

How do I prevent this tooltip display?

Thanks
Kelvin4
0
Comment
Question by:Kelvin4
  • 3
5 Comments
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40433353
0
 

Author Comment

by:Kelvin4
ID: 40433442
Thanks, I downloaded the file: DisableHyerlinkTollTips2. but encountered this error: Module basMain:

Public Sub CreateDll(ByVal Dummy As Boolean)

    Dim Bytes() As Byte
    Dim lFileNum As Integer
    Dim aVar
    Dim x As Long
   
    aVar = ThisWorkbook.Worksheets("dllBytes").UsedRange.Value
     
    ReDim Bytes(LBound(aVar) To UBound(aVar))
    For x = LBound(aVar) To UBound(aVar)
        Bytes(x) = CByte(aVar(x, 1))
    Next
   
    lFileNum = FreeFile
    Open DLL_PATH_NAME For Binary As #lFileNum  '<<<<<<<<<<  Error Here
     Put #lFileNum, 1, Bytes
    Close lFileNum
   
    Call RegisterDll
   
End Sub

There seems little evidence that this offering works in the hands of others?

Any other comments on using this approach? 'Or other approaches?

Thanks again, Kelvin
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 40434541
Can you clarify exactly what steps you take to do this: "- I import a graphic (eg .jpg) into a worksheet cell."
0
 

Author Closing Comment

by:Kelvin4
ID: 40434883
I'm afraid I was not able to evaluate the code supplied at the LINK above, as it has a bug.

I decided to cut my loses and remove the hyperlink

Instead, I increased the space in the WS cell that contained the graphic image. This provided the cursor with enough access to the WS cell, so I could double click the cell and detect that Event via Workbook_SheetBeforeDoubleClick. Coupling that event signal upto the original target of my hyperlink was straightforward. That provided a pretty adequate user-experience.

Always glad to hear of better approaches..
Thanks,
Kelvin
0
 

Author Comment

by:Kelvin4
ID: 40435326
Rory: Thank you - but your message got to me just after I had closed out the Question.
            I've not used graphic icons in spreadsheets before, and ADVICE from a Savant would be prized.
           I am now posting a new question along the lines below.

Last 24 hr: I investigated a variety of procedures.  I realised that I need a clicked Icon to return the Row and column value of the cell it is located in. So I ABANDONED the Hyperlink solution (in the original question), and nor can I see how to get Row and column values from an icon with an assigned macro.

Hence MY FALL BACK SOLUTION is to make the xl cell within which the icon resides sufficiently WIDE for the user to double click part of the cell that is not occupied by Icon. This returns row and column values that will identify the file name and property type (fish etc), respectively. That is not likely to yield a good user-experience!

*** A solution that uses a hyperlink or macro assigned to the Icon would be preferred, provided I could interrogate the cell position of the Icon that was clicked. ***

I add icons to xl cells  via:
    With Range(Cells(rn.row + 1, 7), Cells(rn.row + 1, 1))
        ActiveSheet.Shapes.AddPicture "D:\aaThink_Build\Thk_Building\xlImages\Fish.jpg", msoCTrue, msoTrue, .left, .top, -1, -1
        ActiveSheet.Shapes(ActiveSheet.Shapes.Count).height = .height
    End With

Thanks,
Kelvin
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now