Lock cell and reprotect sheet after save
I have a spreadsheet that tracks performance. Some info is put in by many
different users. Other info is put in by our Admin team. All the cells that
our Admin team updates is locked and the sheet is always protected.
Is there a macro that will lock the cells that the users make changes to
once they have entered and saved the inforation - I am hoping to prevent
changes/deletions once the information has been entered.
I am a novice at vba.
Thankx in advance
|