locking excel cells after data is entered

[comptechbranden]

How would I lock a cell after data is entered? It does not have to be secure locking, just good enough to keep the average user from changing the cells data on accident.

 

[July0212]

You want to be automaticly locked or you want to lock it yourserf after some user enter the data? If you want to lock it yourself is quite easy, al you need to do is to select the cell -> right click-> format cells -> Protection -> select locked and hidden if you want but the worksheet must be protected.

let me know if is what you need

Regards
J.

 

[comptechbranden]

I was wanting it to do it automatically after a normal user enters the data the first time. I know about the protected cells feature. I dont think it is quite what I am looking for. Thanks for any help July.

 

[boblarson]

A quick tip: If you need to know what the code to do something in Excel is, you can start recording a new macro and then do the thing you want to know how to do, and then stop the macro recording and go into the VB window and look under the module (usually Module1 if there wasn't one to begin with) and you can see the code. Sometimes it takes a little tweaking in Access to make it work but for the most part it will give you what you need.

 

[comptechbranden]

I thought about that. Ill give it a try because it seems to be a good tip. Atleast I can look at the code and see what excel came up with and try to use it. Now in my case, I need to do more testing with locking stuff.