I have created a shared workbook to update certain entries by my colleagues. I have noticed that some of the entries were deleted after some time. I want to know if I can share the work with the following feature:-
As soon as somebody enters data to a cell, it should be automatically locked and should not allow anyone to delete or edit the cell.
How do I do it? Please help me. Thanks in advance.
Last edited by mifzal.mufthi; 04-29-2013 at 12:56 PM.
Help me please
You can't use sheet protection when the file is in shared mode
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks but I don't think you have understood the question. I know that protection cannot be enabled while on sharing mode. I know how to enable protection too. What my question is, how do I protect cells as soon as I enter a data? The purpose of doing that is to prevent deleting or modifying data. Once a data is entered, it should automatically lock the cell. How do I do that?Originally Posted by :) Sixthsense :)
You can't use sheet protection when the file is in shared mode
Again, protecting the cell content can't be done without using the sheet protection
READ MY ENGLISH. I know how to protect worksheet. I am expecting a solution to my questionAgain, protecting the cell content can't be done without using the sheet protection
IS THIS IN ENGLISH??? And as you expect a solution to your question and we MUST(we had to.) give a solution...
http://chandoo.org/forums/topic/lock...-entry-in-cell
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I know 0 about coding. So, can you please explain me the step by step process?
if you formulate your request, more politely, be sure that you'll find your solution..
Yes I understand. I've asked the question politely and the person replied didn't seem to have understood the question. I kept repeating. You'll understand if you read the thread. Anyways, will you be able to find a solution for me please?if you formulate your request, more politely, be sure that you'll find your solution..
perhaps you could read your own statement
but thenI know that protection cannot be enabled while on sharing mode.
the answer is clear as you have already outlined-do not use sharing mode. if you must use sharing mode you cannot change the protection of cellshow do I protect cells as soon as I enter a data?
Josie
if at first you don't succeed try doing it the way your wife told you to
I have removed the sharing. Now, how do I accomplish my task?
right click the worksheet tab choose view code then paste in this code
finally I suggest you read your posts again and try and see how they appear to others-it may encourage you to adopt a different tone with the people you want to help you ;-)
Please Login or Register to view this content.
Thanks buddy. It worked only once. I mean, only 1 entry is allowed and it locks automatically. I should be able to enter so many entries and as we enter entries, they should be locked. Thanks for your effort again. Please refer the attachedright click the worksheet tab choose view code then paste in this code
finally I suggest you read your posts again and try and see how they appear to others-it may encourage you to adopt a different tone with the people you want to help you ;-)Please Login or Register to view this content.
you need to unlock all the cells you want the user to be able to change before you start-Locked is the default setting
An alternative approach without using sheet protection. It *may* work for you and may even work in a shared workbook ... but no guarantees.
It uses Worksheet_SelectionChange to monitor the cells. Once data has been entered, you cannot select the cell(s) again. It "homes" to cell A1 if a completed cell is selected. You could limit the range that is monitored and you could pick a different cell to home to. However, you do need to move away from the selected cell.
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks