Hi,
Is there a way to hightlight or change the cell colour if values on that cell is changed?
apply this condition for the whole worksheet, if any values is changed after the last save, change the color of the cell
I know we can do this by using track changes but this forces the user to shared the workbook?
Thanks and regards
Arvind
You can use something like this.
Private Sub Worksheet_Change(ByVal Target As Range) Target.Interior.ColorIndex = 3 End Sub
The code needs to sit on the worksheet's code page. Right click on the sheet tab and select view code.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks