I want know how can Lock a cell automatically after editing or writing in that cell. It means when i write anything in a specific cell after writing it become lock automatically with a specific Password that i give it and no one can edited twice without entering password. I mean that the specific cell must be unlocked for first time editing and become lock for second time and so on. Please send me A Macro or other to able I do this. Thanks
This assumes that cell B9 starts out unlocked. Put this macro in the worksheet code area:
This is an Event Macro:
Please Login or Register to view this content.
Because it is worksheet code, it is very easy to install and automatic to use:
1. right-click the tab name near the bottom of the Excel windowIf you have any concerns, first try it on a trial worksheet.
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window
If you save the workbook, the macro will be saved with it.
To remove the macro:
1. bring up the VBE windows as aboveTo learn more about macros in general, see:
2. clear the code out
3. close the VBE window
http://www.mvps.org/dmcritchie/excel/getstarted.htm
To learn more about Event Macros (worksheet code), see:
http://www.mvps.org/dmcritchie/excel/event.htm
Macros must be enabled for this to work!
Gary's Student
Hi dear my Friend!
Your Macro code is the best but i want that when i type any thing in cell B9 just lock cell B9 and when i type any thing in cell B10 lock cell B10 not all sheet. Please help my dear brother.
Hi dear my Friend!
Your Macro code is the best but i want that when i type any thing in cell B9 just lock cell B9 and when i type any thing in cell B10 lock cell B10 not all sheet. Please help my dear brother.
Here is a different version. It will lock any cell after the cell has been filled:
You must erase the first version.Please Login or Register to view this content.
I am thinking that you don't receive my aim. I want that when any one write some thing in cell A1 just this cell must lock and after that when he write any thing in cell B6 just A1 and B6 must lock not whole sheet and so on please help me my dear.
It is a matter of the order of things.
- start with all ( or most) cells unlocked
- enter the macro
At this point you (or the user) can enter a value in any cell. Once you have entered the value, that single cell becomes locked, even though the worksheet is protected, the other cells are not yet locked and values may be entered into them.
I have attached an example.
when i have many cell like for fees paid when i write paid in cell A4 just this well lock but when i write paid in A5 this is not lock. I want that this code select a range and after every typing it must update and lock the second cell too. thanks dear.
Thanks my problem was solved. So much thanks my real friend.
If you any further help, update this post or open another.
Dear Jakobshavn Please can you Edit your Automatic Cell Locking Macro Code For a Specific Range I mean Edit this macro code to work or apply in a specific range like (B7:D9) please don't Forget me.
Here it is
Thanks. Your Macro Code was Great. Please help in this tread too with your kindness : http://www.excelforum.com/excel-gene...html?p=3036420
How do I view this coding so that I Can use it for other excelOriginally Posted by Jakobshavn
Here is the code:
The instructions to view, install, and remove this type of code were given in my first post.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks