| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock Each Cell After Edit
Hi Guys,
I need to lock cell whenever it gets edited. for example if I edit A1 than after editing A1 needs password to edit again similarly to other cells. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lock Each Cell After Edit
Hi Guys,
I need to lock cell whenever it gets edited. for example if I edit A1 than after editing A1 needs password to edit again similarly to other cells. The code you found from Gord does this IF you prepare the sheet as he instructs in his 1st reply to that thread. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I lock a cell's format but still allow to edit it's value? | Excel Discussion (Misc queries) | |||
| Lock certain cells from edit- test if select cell name starting wi | Excel Programming | |||
| Can I lock formatting in Excel while keeping the ability to edit? | Excel Discussion (Misc queries) | |||
| How do i lock tabs so that only an admin can edit them? | Excel Discussion (Misc queries) | |||
| Lock a cell from others to edit? | Excel Worksheet Functions | |||
Hybrid Mode
