Quick Question,
In excel 2016, I want to track all my changes but when i make a change on the workbook, i want to record the reason for the change on the history sheet. I wanted to do this by adding another column in the history sheet tab but the sheet is protected.
Is there any possible way to unprotect the sheet or does anyone have other ideas to help? I cannot put comments on the cells or anything so i am kind of stuck.
Thanks in advance.
In excel 2016, I want to track all my changes but when i make a change on the workbook, i want to record the reason for the change on the history sheet. I wanted to do this by adding another column in the history sheet tab but the sheet is protected.
Is there any possible way to unprotect the sheet or does anyone have other ideas to help? I cannot put comments on the cells or anything so i am kind of stuck.
Thanks in advance.
