My purpose is to find out how, if possible, to have a cell in worksheet B that is linked to a cell in worksheet A (i.e. worksheets in the same workbook) automatically highlight the same color as the linked cell in worksheet A when it is highlighted any given color.
Okay, attached is a folder w/ 2 files in it. The original one you posted, and then I moved sheet2 to another book (Book1.xls) for the testing - as you said you wanted this in 2 different workbooks. Well, w/o doing some other advanced calls in dealing w/ closed workbooks (which I'm not yet proficient in) I set this up as you have to have the 2nd workbook open. The current code will pop up a msg box if it's not open. You'll also have to set the range manually in the code.
Highlights of the year - physicsworld.com::
Astronomers solved a long-standing puzzle in solar physics this year with The tiny rolled sheets of graphite have been shown to possess surprising
http://physicsworld.com/cws/article/news/4969HOME |
An Attitudinal Survey of Classroom Response Systems::
File Format: PDF/Adobe Acrobat - View as HTMLsame worksheet tab. This copy will serve as the “worksheet’s solution”. 3. Select (highlight) the cells containing the initial model and apply conditional
http://www.abe.sju.edu/proc2007/blazer.pdfHOME |
It's probably not the best/most efficient code out there, but it works for me in 2000.
Let me know if it works for you.
I had problems with that code. It would do it automatically or consistently. I'm not sure if there was just a waiting period or what. I've attached an example that should help you better understand what I'm trying to do. Also, is there a way to do it between workbooks (i.e. having half of sheet 1 in one workbook, the other half in another, and both linked to the main workbook that would automatically highlight based on the first two.
Science Express Highlights::
The tetramer structure differs from a presynaptic complex between dimeric level rise that resulted from the melting of ice sheets after the Last Glacial
http://www.sciencemag.org/feature/express/expresstwise.dtlHOME |
Extensible Markup Language Highlights - XML '97::
We will cover the differences between the two and the reasons behind the . This talk will cover the relationship between: XML syntax and the ATA text
http://xml.coverpages.org/xml97Highlights.htmlHOME |
Thanks
Oops, somehow a line was taken out. I originally had ...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim x As Long
x = Target.Interior.ColorIndex
If Target.Address <> "$A$1" Then Exit Sub
Sheets("Sheet1").Range("A1").Interior.ColorIndex = x
End Sub
Hi,
Something like this may help ...
Chemical & Engineering News: Cover Story - Chemistry Highlights 2005::
Dec 19, 2005 Eisenberg and coworkers solved the problem by growing tiny crystals Evidence for the first quintuple-like bond between two metal atoms
http://pubs.acs.org/cen/coverstory/83/8351chemreview.htmlHOME |
Excel 2007 highlights Video – 5min.com::
Excel 2007 highlights - One of the annoying things about Excel 2007 is that the color for selected sheets and cells is almost identical to the color for
http://www.5min.com/Video/Learn-Excel-from-MrExcel-Episode-907---2007-Highlighted-Sheets-80753415HOME |
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim x As Long
x = Target.Interior.ColorIndex
Sheets("Sheet1").Range("A1").Interior.ColorIndex = x
End Sub
With this in Sheet2 module (right click sheet tab -> View Code) it will change Sheet1 A1 to the same highlight. HTH
 Traditional University or MLM University? You Choose
 15 Questions to Ask Your Software Vendor
|
Solved: Highlights between worksheets