Locked fields
$10-30 USD
Paid on delivery
I've created a tracking spread sheet that reformats when a certification is due for renewal. I've followed the instructions to lock cells (to protect the calculations) but the selected cells won't lock. just the portion outside of the active columns and rows. below are the instructions I use. It works when I create a new spreadsheet, but not after amending.
:Highlight cells to remain open
Rt click; Format cells; Protection tab.
Uncheck "locked"; ok.
Review tab; Protect sheet;
check "select unlocked cells"
all others unchecked.
password protect; OK
How do I correct this? Using version 2010
Project: All highlighted cells should be locked, all else unlocked.
Project ID: #17101853
About the project
12 freelancers are bidding on average $23 for this job
Hello, I can help with you in your project Locked fields. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Microsoft, Visual Basic. We have worked on several similar projects before! We More
Hello Sir I can locked field like u want in your tracking spreadsheet Sir :) because im excel programer :) please chat me for discuss detail of your project and im able to start working right now Thank You Since More
Hi, I ave multiple years of experience in MS-Excel, functions, macros etc. I have checked your project post, issue and the attached sheet. I will surely assist you with this issue. Please allow me to work on your pr More
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA and all the functions. I can give a solution of the problem you are getting with locked cells. Please come on chat for more details. More
This easily done by using validation check or can write a simple VBA for this, no need to pay more than 10$ for this simple assignment. can give within one hour or less. please inbox me for more information
