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.

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