Highlight changes in all-links spreadsheet

  • Thread starter Martin ©¿©¬ martin
  • Start date
M

Martin ©¿©¬ martin

Hi
I have 12 pages with code to highlight/colour changes made
=========================================================
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 8
End Sub
================================================

I then have to *copy/paste special - all links* from each of the 12
pages into another page to have a total overview.
Is it possible to have a code to highlight/colour the changes made in
the overview page when a change is made to any of the 12 pages?

Martin
©¿©¬
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Excel VB, Update a specific cell, on any change of anotherspecific cell 2
Change colour of data when changed 3
please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? 1
Change colour of cells when content is altered/changed 5
Conditional formatting in VBA not working 3
Highlight a cell after update in a specific range 2
Remoew row highlighting when workbook is closed 5
Cell Protection 1

Top