+ Reply to Thread
Results 1 to 8 of 8

can't remove 'javascript:void(0);' arrow symbol

Hybrid View

  1. #1
    Registered User
    Join Date
    04-11-2023
    Location
    Palm Coast, FL
    MS-Off Ver
    2019
    Posts
    4

    can't remove 'javascript:void(0);' arrow symbol

    After copying some spreadsheet data from a bank website into a an Excel spreadsheet on my PC, I got a small right-pointing arrow symbol in small square at the beginning of a row. When I click on that arrow I get this message in a popup:
    "Microsoft Office has identified a potential security concern.
    This location may be unsafe.
    javascript:void(0);"
    I have tried to delete the arrow with the Delete key: Nope.
    I have tried right-click and 'Remove hyperlink': Nope.
    I have selected a range of rows to include the arrow symbol and deleted them: The arrow symbol remains.
    I've done lots of searching - I can't find a way to remove it.
    Does anyone on this forum know how to remove it?

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: can't remove 'javascript:void(0);' arrow symbol


    The better is to not copy it …

  3. #3
    Registered User
    Join Date
    04-11-2023
    Location
    Palm Coast, FL
    MS-Off Ver
    2019
    Posts
    4

    Re: can't remove 'javascript:void(0);' arrow symbol

    Well, sure, I know now that it's better not to have copied the data, but knowing that now doesn't get rid of the non-functional javascript arrow.

  4. #4
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: can't remove 'javascript:void(0);' arrow symbol

    Upload sample file showing this anomaly...Sure someone will figure it out for you...
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  5. #5
    Registered User
    Join Date
    04-11-2023
    Location
    Palm Coast, FL
    MS-Off Ver
    2019
    Posts
    4

    Re: can't remove 'javascript:void(0);' arrow symbol

    Here's a sample file showing the anomaly
    Attached Files Attached Files

  6. #6
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: can't remove 'javascript:void(0);' arrow symbol

    This works for me...
    ActiveSheet.Pictures.Delete
    I am also able to manually delete them...The pic in row 15 has 4 on top of each other...
    Last edited by Sintek; 04-11-2023 at 09:17 AM.

  7. #7
    Registered User
    Join Date
    04-11-2023
    Location
    Palm Coast, FL
    MS-Off Ver
    2019
    Posts
    4

    Re: can't remove 'javascript:void(0);' arrow symbol

    sintek - In all honesty I don't know what to do with 'ActiveSheet.Pictures.Delete' but no matter. Your revelation that multiple symbols could be stacked on each other had me re-try the manual delete method (which I had tried multiple times before posting this thread so maybe it started with 8 or 9 stacked?) and that did the trick. When I tried manual deletion I had no idea there could be multiples so after deleting several times with no visible result I thought it wasn't working... Thanks much for the help.

  8. #8
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: can't remove 'javascript:void(0);' arrow symbol

    I don't know what to do with 'ActiveSheet.Pictures.Delete'
    It is code...goes into a module...See attached...Open, enable macros...push the button
    Attached Files Attached Files

+ 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. how to remove the second currency symbol?
    By unhinged in forum Excel General
    Replies: 4
    Last Post: 05-23-2021, 08:56 PM
  2. [SOLVED] macro to remove comment arrow only
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-31-2020, 02:09 PM
  3. remove drop down arrow from table
    By jc2398 in forum Excel General
    Replies: 2
    Last Post: 06-14-2014, 10:09 AM
  4. Remove A Filter Arrow?
    By theghost in forum Excel General
    Replies: 8
    Last Post: 02-15-2012, 12:49 PM
  5. Replies: 2
    Last Post: 07-01-2010, 06:34 PM
  6. copy from webpage pulls in javascript icon, how to remove?
    By scrubbie1 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-24-2007, 09:57 PM
  7. [SOLVED] remove comment arrow
    By john mcmichael in forum Excel General
    Replies: 2
    Last Post: 02-13-2006, 04:45 PM

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