+ Reply to Thread
Results 1 to 5 of 5

Add ScreenTip (Hyperlink) to certain shapes

  1. #1
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 365
    Posts
    481

    Add ScreenTip (Hyperlink) to certain shapes

    Hi all,

    I'm trying to add a ScreenTip (Hyperlink) to certain shapes within a sheet. It works perfectly fine with some of them, however, for some others, I get the error message "Application-defined or object-defined error". As a comparison, if the shape name would be wrong (I tried), I get the error "The item with the specific name wasn't found" instead. So the names seem to be correct. I don't understand why Excel let's me add a screentip to some but not to others within the same sheet?

    Please Login or Register  to view this content.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Add ScreenTip (Hyperlink) to certain shapes

    Are you sure the shapes you are referring to actually have a hyperlink?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 365
    Posts
    481

    Re: Add ScreenTip (Hyperlink) to certain shapes

    Not sure what exactly you mean...

    They are not supposed to have a working hyperlink, there are only supposed to show a screentip with the name of the province when hovering over the shape. See below:

    forum screentip.png

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Add ScreenTip (Hyperlink) to certain shapes

    If the shape doesn't have a hyperlink assigned to it you will get a 1004 error if you try to assign a screen tip to the non-existent hyperlink.

  5. #5
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 365
    Posts
    481

    Re: Add ScreenTip (Hyperlink) to certain shapes

    Sorry for the late reply, just figured it out! It was the missing hyperlink indeed in one or two of the shapes!!! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hyperlink Screentip not appearing properly
    By PlopNofear in forum Excel General
    Replies: 3
    Last Post: 06-12-2015, 12:25 PM
  2. [SOLVED] Formating a Hyperlink Screentip
    By ie08jtw in forum Excel General
    Replies: 6
    Last Post: 08-01-2012, 08:23 AM
  3. Shape Hyperlink Screentip macro
    By andy1787 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2011, 10:42 AM
  4. Suppress or Edit ScreenTip Hyperlink as formula
    By niks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2011, 10:12 AM
  5. Screentip / Hyperlink & Button/Shape
    By Tord in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2010, 10:31 AM
  6. Hyperlink with no ScreenTip ?
    By Phil_V in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-08-2009, 10:40 AM
  7. How to extract the ScreenTip text from a hyperlink field
    By arobbo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2009, 11:26 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1