| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I lock a picture with a cell so it sorts with the sheet | Excel Discussion (Misc queries) | |||
| Lock Hyperlink to cell in different sheet | Excel Discussion (Misc queries) | |||
| Protect then reprotect using macro | Excel Discussion (Misc queries) | |||
| how do i lock a cell? to save formula or function in it? | Excel Discussion (Misc queries) | |||
| lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
Threaded Mode
