We help IT Professionals succeed at work.

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

Kelvin4
Kelvin4 asked
on
110 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
Comment
Watch Question

Microsoft Excel Expert
CERTIFIED EXPERT
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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
Rory ArchibaldGrand Poobah
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011

Commented:
Can you clarify exactly what steps you take to do this: "- I import a graphic (eg .jpg) into a worksheet cell."

Author

Commented:
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

Author

Commented:
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

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.