Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight and email
Hi, is it possible to highlight the cell/cells (where changes were made) and
email the row/rows with the column names if any changes are made to the file. [email to be sent out when user select to save the file and i have 3 recepients who should receive email about the change]. Please Help Thanks Mir Khan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight and email
See this for the email part:
http://www.rondebruin.nl/sendmail.htm Try this code for the compare part: Sub Compare2Shts() For Each Cell In Worksheets("CompareSheet#1").UsedRange If Cell.Value < Worksheets("CompareSheet#2").Range(Cell.Address) Then Cell.Interior.ColorIndex = 3 End If Next For Each Cell In Worksheets("CompareSheet#2").UsedRange If Cell.Value < Worksheets("CompareSheet#1").Range(Cell.Address) Then Cell.Interior.ColorIndex = 3 End If Next End Sub Regards, Ryan--- -- RyGuy "Mir Khan" wrote: Hi, is it possible to highlight the cell/cells (where changes were made) and email the row/rows with the column names if any changes are made to the file. [email to be sent out when user select to save the file and i have 3 recepients who should receive email about the change]. Please Help Thanks Mir Khan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight Cell that contains invalid email format | Excel Worksheet Functions | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |