Greetings
I currently need to lock some formulas in a worksheet to eliminate the possibility of the user writing on top of it. The user needs to fill in some information in the sheet, reason for not locking the whole thing. I know this can be done with VBA code but, is there a different way of doing it?
Thanks in advance!
Hi-light all of the cells in the sheet, unlock them, then lock the few that you want locking and protect the sheet.
Click * below if this answer helped
You can unlock cells that you want the user to be able to enter data into and still lock the worksheet. That's the way most worksheets work.
Let's say Data will be entered into A2:C500 and F2:F500 but you want the rest locked.
Select that range only, right click > Format cells> Protection Tab> Uncheck "Locked"
Then when you protect the worksheet, the "unlocked" cells can still accept data.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks, Ill try it
Thanks for the explanation, worked perfectly. Feel kind of silly, have been trying for a whiiiile to lock the cells and what I needed to do was to unlock the one I needed to be unlocked.
Thanks
Glad to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks