I want to create a history of changes I make to a data file. Other people use this to run macros out of. The sheet must remain protected (except when running macros and when I am updating the information). I want to list the file/sheetname/cell location/old value/new value/date/time. This will create an electronic trail I or someone else can follow when trying to resolve why numbers are not matching up in my dept. I do like the history file created when sharing a file however I cannot share. The data sheet must be protected. Any help is greatly appreciated.