+ Reply to Thread
Results 1 to 13 of 13

Highlight cell when source file is updated

Hybrid View

  1. 05-10-2010, 05:20 AM #1
    pike
    pike is offline
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Highlight cell when source file is updated

    hi ChinShiong,
    This may do the trick.
    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
 Application.EnableEvents = False
 Target.Font.Color = vbRed
 Application.EnableEvents = True
End Sub
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs
    Reply With QuoteRegister To Reply
  2. 05-10-2010, 05:50 AM #2
    ChinShiong
    ChinShiong is offline
    Registered User
    Join Date
    05-10-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Highlight cell when source file is updated

    Thanks for the reply pike, but it doesn't work. Maybe I'm doing something wrong ?

    I opened Excel file A, right click on the sheet name, click "view code", and pasted the code there, and saved the file.

    Then I open the source file and changed the value. When I opened file A again to update the links to file B, the numbers are updated, but the font doesn't get highlighted to red. Any thoughts on this ?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1