Auto updating of excel sheet ? | AccountingWEB

Auto updating of excel sheet ?

I have an excel sheet which contains work carried out that also requires reviewing. Once approved initials are placed say in cell A20 in a box and will always appear at the same place on all sheets.

Is there any way to ensure that if the sheet is altered at all then the initials in cell A20 wil be erased thereby indicating the sheet had to be re-reviewed ? (the cell would need to be protected to prevent reviewers initials being entered by anyone else)


There are 2 comments. Login or register to view them.

There is with VBA

ACDWebb |
ACDWebb's picture

Thanks. Will give it a try. The sheet is

stu |