Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,182
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I lock a cell's format but still allow to edit it's value? hitchb Excel Discussion (Misc queries) 1 March 8th 10 08:16 PM
Lock certain cells from edit- test if select cell name starting wi Daniel W Excel Programming 2 July 27th 09 04:51 PM
Can I lock formatting in Excel while keeping the ability to edit? DK Excel Discussion (Misc queries) 1 March 24th 09 08:52 PM
How do i lock tabs so that only an admin can edit them? Dave_FFM Excel Discussion (Misc queries) 2 April 27th 07 02:00 PM
Lock a cell from others to edit? tb Excel Worksheet Functions 3 June 1st 06 06:07 PM


All times are GMT +1. The time now is 08:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"