+ Reply to Thread
Results 1 to 9 of 9

Fire up Worksheet_Change

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Fire up Worksheet_Change

    Hello
    I have the following code
    Please Login or Register  to view this content.
    The code make hyperlinks to pdf files in the same path
    when entering a value in my range A2:A10000 , if the file exists the code make a hyperlink
    If I entered some values for non-existing pdf files and save my excel file then I put my pdf files with the names I have already entered... When opening my workbook the hyperlinks can not be done unless I double click every cell

    I want to update the hyperlinks at once

    I tried pressing F9 but it is useless

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Fire up Worksheet_Change

    Untested, but you could try selecting all the cells that are populated, copying them and pasting them (without changing the selection).

    In theory, that should fire the WSC event handler and the Target would include all the existing hyperlinks.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Fire up Worksheet_Change

    This is an attachment
    Try to rename pdf files and open the workbook and see the results
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Fire up Worksheet_Change

    Is there a way to make results up to date as soon as opening the workbook?

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Fire up Worksheet_Change

    Please Can I find any solution?

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Fire up Worksheet_Change

    Any information may help solving the problem

  7. #7
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Fire up Worksheet_Change

    Change your worksheet module code to:
    Please Login or Register  to view this content.
    Add this code to your workbook module:
    Please Login or Register  to view this content.

    Add this code to a standard module:
    Please Login or Register  to view this content.

    Working example attached.
    Attached Files Attached Files
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  8. #8
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Fire up Worksheet_Change

    Really Fantastic
    Really Wonderful
    Really You are excellent and brilliant
    Thank you very much for offering me help

  9. #9
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Fire up Worksheet_Change

    Happy to help! Thanks for the feedback

+ 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. Worksheet_change doesn't fire
    By passant6 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-19-2011, 09:05 AM
  2. Worksheet_Change Function doesn't fire
    By chauhan4 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2010, 07:58 PM
  3. Make Worksheet_Change() event sub fire on external link changes
    By batman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2009, 10:00 PM
  4. Need help for fire department
    By sta224ffemt in forum Excel General
    Replies: 2
    Last Post: 12-11-2006, 04:16 PM
  5. [SOLVED] Code will not fire
    By Ray A in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-01-2006, 01: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