PivotMeThis
Active Member
- Joined
- Jun 24, 2002
- Messages
- 346
I have a second post about copy/paste on the board that deals with the same worksheet but this is a different issue. The data that I am working with are made up of projects and contracts. A contract can have several projects and the data is sorted so that the projects are together on several rows that make up the contract. On the first row of each group of projects are formulas to add up the project costs for each contract and well as project status information that is updated weekly by several people.
When this data is updated I have a little code that turns the font blue. I thought this was pretty slick (and it is, to a point) and that point is, it will always be blue.
The problem is, that after this group of people make their updates, there is another person who will review these updates and make possible corrections. When she is done, I'd like the font to return to black - with the help of a button or checkbox that she can select. A checkbox for each contract would be nice but there is project information between some of these lines. I have placed an "X" in column A for each contract line if that is helpful. If that idea is not an option, just one button for the entire sheet, so when she finishes editing it returns to blue.
This report is updated weekly. It's something that will reside on our network with several people working on it.
When this data is updated I have a little code that turns the font blue. I thought this was pretty slick (and it is, to a point) and that point is, it will always be blue.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Font.ColorIndex = 5
End Sub
The problem is, that after this group of people make their updates, there is another person who will review these updates and make possible corrections. When she is done, I'd like the font to return to black - with the help of a button or checkbox that she can select. A checkbox for each contract would be nice but there is project information between some of these lines. I have placed an "X" in column A for each contract line if that is helpful. If that idea is not an option, just one button for the entire sheet, so when she finishes editing it returns to blue.
This report is updated weekly. It's something that will reside on our network with several people working on it.