Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Automatically Protect/lock Workshee
Name: xtremedude Date: December 10, 2008 at 11:45:38 Pacific OS: win xp CPU/Ram: P4 & 512 Product: Dell DIMENSION
Comment:
Hi Guys, I'm preparing an Technology downtime tracker in which the Managers have to put in details of the time dueto which they were un-productive....the file will remain open for for 24 hrs for each day, and after that, post 24 hrs...the file will be automatically locked showing some error msg like "Time Over For Changes" etc....this will continueuntil n unless i allow changes to be made after 24 hrs...kinna ADMIN access to the entire sheet.........
Summary: Highlight the Cells. Format, Cells, Protection, Locked. Then, protect the sheet when done. Life is more painless for those who are brainless....
Summary: Exact : This way works only for a protection which has been set in tools/protection/lock sheet/folder.... and doesn't work if protection was set in register/options ):-( ...
Summary: First, you can't have b1 in B2 and b2 in B2, so I'll assume that's a typo. Second, look at the Named Range feature. Select A1:B2 and do one of the following: 1 - Just above cell A1 you should see a bo...
