Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Tracking Changes
Hello All Experts,
I have an excel 2003 workbook with multiple tabs that are updated weekly. Currently, the users highlight their weekly changes and once I update the master worksheet I unhighlight these cells. Is there an easier way to track changes? Please keep in mind that the worksheet the users are updating is housed on an older version of sharepoint. So we are unable to share a workbook. Thank you for any insight and have a nice weekend! Can I create a summary tab for the weekly updates that automatically updates when someone updates a cell in the seperate tabs? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Tracking Changes
Hi,
Although you can track changes in a Shared workbook, I don't think much of them, so the fact that you can't use them under sharepoint is no loss. You could have a macro highlight the changes when they are made and another one to remove the highligthing. Here is some sample code: Private Sub Worksheet_Change(ByVal Target As Range) Dim isect As Range 'Set isect = Application.Intersect(Target, Range("A1")) you don't need this line unless you want to limit the area that gets formatted, if so change A1 to that range. If Not isect Is Nothing Then Target.Interior.ColorIndex = 42 End If End Sub Not all changes will trigger this macro. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Iona" wrote: Hello All Experts, I have an excel 2003 workbook with multiple tabs that are updated weekly. Currently, the users highlight their weekly changes and once I update the master worksheet I unhighlight these cells. Is there an easier way to track changes? Please keep in mind that the worksheet the users are updating is housed on an older version of sharepoint. So we are unable to share a workbook. Thank you for any insight and have a nice weekend! Can I create a summary tab for the weekly updates that automatically updates when someone updates a cell in the seperate tabs? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tracking Changes in Excel | Excel Discussion (Misc queries) | |||
Tracking changes in excel | Excel Discussion (Misc queries) | |||
tracking changes in excel | Excel Discussion (Misc queries) | |||
How to insert tracking numbers into my webpage for RMA tracking | Excel Discussion (Misc queries) | |||
vacation tracking in excel | Setting up and Configuration of Excel |