Logging changes made

[cody.starr]

I have a master spreadsheet that i need to control changes made by others. I would like the spreadsheet to prompt the user upon pressing the save button, if changes are made, to input information into the log sheet, or auto log by network id, computer name, etc.

[xladept]

Try the Before Save event for your prompt:

Please Login or Register  to view this content.

This code would go in the ThisWorkbook module.