Hi every one,
I'm fairly new to excel and am pretty much self taught and learning as i go, I've got a sheet i use at work to track multiple people's productivity and have ran into an issue where people are going back and changing numbers for hours previous and was wondering if there is any way to format the cells to lock after a specified time? Thanks in advance for any help.
or if it is simpler is there away to lock a cell if say the value of 0 was input?
In all cells or a specific range?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
the employees input their numbers into D4:N4,D5:N5,D6:N6,D7:N7 and also in D14:N14,D15:N15,D16:N16,D17:N17
So if 0 is input into any of those cells then you want them locked?
Yes, That would work, Each column represents a work hour. Ideally I would like to find a way to set each cell in that range to lock at the end of that work hour, however locking them after 0 has been input should get the job done.
try
Please Login or Register to view this content.
that gives me a unable to set lock status does being password protected have any effect on that?
For future reference, please do not post duplicate threads
http://www.excelforum.com/excel-form...-set-time.html
I have closed that 1 (after I had already replied to you). You may continue on this 1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Dibbins maybe you should copy over your reply
I didnt copy it across because it wasnt much of a reply, but it can be viewed by clicking on the link
Probably if its password protected at the time.that gives me a unable to set lock status does being password protected have any effect on that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks